Question About Scripting Objects

Hello all,

I was just using Management Studio to script objects on one server to create on another server and I noticed an issue that I need assistance with. When you right-click a table and choose to Script Table As --> Create To --> ..., it scripts the Create Table fine, but if the table has any Primary Keys, Foreign Keys, Constraints, etc., these objects don't get scripted with the Create Table. You have to manually script these objects as well.

I believe in SQL Server 2000, you had the choice of which objects to get created when you wanted to generate the script. Is there an easy way to do this in SSMS? If so, how?

Thanks,

Jason

Nevermind ... it's working now. The developer was adding the PK to the table while I was scripting it so there wasn't a PK to generate at the time of my scripting. Once he added the PK, I was able to generate the script, which included the PK as part of the Create script.

Jason

|||

I have a similar problem. I need to create scripts with the DROP object syntax at the top. This was possible in SQL-2000.

Any help in setting these options for SQL-2005 would be great.

-Rajiv

|||

Rajiv,

I think in SQL Server 2005 you have to generate the DROP independent of the CREATE. I don't think there is an option to generate both commands at once like there was in SQL Server 2000. I could be wrong though, but I haven't been able to find anything comparable in SQL Server 2005. Maybe Microsoft will correct that in a future service pack.

Jason

sql

Question About Scripting Objects

Hello all,

I was just using Management Studio to script objects on one server to create on another server and I noticed an issue that I need assistance with. When you right-click a table and choose to Script Table As --> Create To --> ..., it scripts the Create Table fine, but if the table has any Primary Keys, Foreign Keys, Constraints, etc., these objects don't get scripted with the Create Table. You have to manually script these objects as well.

I believe in SQL Server 2000, you had the choice of which objects to get created when you wanted to generate the script. Is there an easy way to do this in SSMS? If so, how?

Thanks,

Jason

Nevermind ... it's working now. The developer was adding the PK to the table while I was scripting it so there wasn't a PK to generate at the time of my scripting. Once he added the PK, I was able to generate the script, which included the PK as part of the Create script.

Jason

|||

I have a similar problem. I need to create scripts with the DROP object syntax at the top. This was possible in SQL-2000.

Any help in setting these options for SQL-2005 would be great.

-Rajiv

|||

Rajiv,

I think in SQL Server 2005 you have to generate the DROP independent of the CREATE. I don't think there is an option to generate both commands at once like there was in SQL Server 2000. I could be wrong though, but I haven't been able to find anything comparable in SQL Server 2005. Maybe Microsoft will correct that in a future service pack.

Jason

Question about sa on SQL Server 2005

When installing SQL Server 2005 it never asked me for "sa" password. When
trying to login to SQL Server Management Studio, if I want to login as sa,
what is the password for sa ?
Inside SQL Server Management Studio I changed the password for sa, click
OK, and when trying to login to SQL Server Management Studio again with sa
and the password that I just changed it to, it did not let me. It tells me
"Login failed for user sa. Reason: Not associated with a trusted SQL Server
connection. Microsoft SQL Server, error: 18452".
Thank you.
Are you using Windows or SQL authentication with SQL 2005?
fniles wrote:
> When installing SQL Server 2005 it never asked me for "sa" password. When
> trying to login to SQL Server Management Studio, if I want to login as sa,
> what is the password for sa ?
> Inside SQL Server Management Studio I changed the password for sa, click
> OK, and when trying to login to SQL Server Management Studio again with sa
> and the password that I just changed it to, it did not let me. It tells me
> "Login failed for user sa. Reason: Not associated with a trusted SQL Server
> connection. Microsoft SQL Server, error: 18452".
> Thank you.
>
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email
|||During installation it did not ask me if I want to use Windows or SQL
Authentication, should it ?
Since I do not know the password for sa, I logged in using Windows
Authentication.
I also posted this in another thread:
when I go to the SQL Server Management Studio and connect to the
Object Explorer and select my Server (there are 2 options for this),
when I select 1 of the server it says SQL Server 8.0.384 and the other
server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
Where is my SQL Server 2005 ?
Thank you.
On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> Are you using Windows or SQL authentication with SQL 2005?
> fniles wrote:
>
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email
|||You can change that from Management studio if I remember correctly.
Did you select the browse and see if SQL 2005 is listed?
fiefie.niles@.gmail.com wrote:
> During installation it did not ask me if I want to use Windows or SQL
> Authentication, should it ?
> Since I do not know the password for sa, I logged in using Windows
> Authentication.
> I also posted this in another thread:
> when I go to the SQL Server Management Studio and connect to the
> Object Explorer and select my Server (there are 2 options for this),
> when I select 1 of the server it says SQL Server 8.0.384 and the other
> server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
> Where is my SQL Server 2005 ?
> Thank you.
> On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> wrote:
>
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email
|||Thank you.

>You can change that from Management studio if I remember correctly.
Change it to what ?

>Did you select the browse and see if SQL 2005 is listed?
Did you mean browse the "Server Name" ?
When I do that under "Database Engine" there are 2 things listed.
-myComputername\SDK
-myComputername
When I select myComputername\SDK it is SQL Server 8.0.384
When I select myComputername it is SQL Server 8.0.194
Is it possible that I only installed the client portion of the
installation ? I selected everything at installation, and the DVD is
titled "SQL Server 2005 Standard Edition"
On May 19, 9:02 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> You can change that from Management studio if I remember correctly.
> Did you select the browse and see if SQL 2005 is listed?
>
>
> fiefie.ni...@.gmail.com wrote:
>
>
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email- Hide quoted text -
> - Show quoted text -
|||Change the authentication from Windows to SQL
When you start Management Studio you get a short list of SQL Servers.
If you click the arrow you get a list which contains "Browse for more".
Clicking on that lists everything it knows about.
If you selected database engine you should have a server.
fiefie.niles@.gmail.com wrote:
> Thank you.
> Change it to what ?
> Did you mean browse the "Server Name" ?
> When I do that under "Database Engine" there are 2 things listed.
> -myComputername\SDK
> -myComputername
> When I select myComputername\SDK it is SQL Server 8.0.384
> When I select myComputername it is SQL Server 8.0.194
> Is it possible that I only installed the client portion of the
> installation ? I selected everything at installation, and the DVD is
> titled "SQL Server 2005 Standard Edition"
>
>
> On May 19, 9:02 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> wrote:
>
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email
|||Thanks.
I can't change to SQL Authentication because I do not know the
password for sa. During installation it did not ask me for sa's
password.
When I click the "Browse for more" in the the "Server Name" , under
"Database Engine" there are 2 things listed.
-myComputername\SDK
-myComputername
When I select myComputername\SDK it is SQL Server 8.0.384
When I select myComputername it is SQL Server 8.0.194
None of them is SQL 2005.
During installation I selected all of the following:
1. SQL Server Database Services
2. Analysis Services
3. Reporting Services
4.Notification Services
5. Integration Services
6. Workstation components, books online & development tools
My machine is Win XP Professional SP2.
On May 19, 10:27 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> Change the authentication from Windows to SQL
> When you start Management Studio you get a short list of SQL Servers.
> If you click the arrow you get a list which contains "Browse for more".
> Clicking on that lists everything it knows about.
> If you selected database engine you should have a server.
>
>
> fiefie.ni...@.gmail.com wrote:
>
>
>
>
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email- Hide quoted text -
> - Show quoted text -

Question about sa on SQL Server 2005

When installing SQL Server 2005 it never asked me for "sa" password. When
trying to login to SQL Server Management Studio, if I want to login as sa,
what is the password for sa ?
Inside SQL Server Management Studio I changed the password for sa, click
OK, and when trying to login to SQL Server Management Studio again with sa
and the password that I just changed it to, it did not let me. It tells me
"Login failed for user sa. Reason: Not associated with a trusted SQL Server
connection. Microsoft SQL Server, error: 18452".
Thank you.Are you using Windows or SQL authentication with SQL 2005?
fniles wrote:
> When installing SQL Server 2005 it never asked me for "sa" password. When
> trying to login to SQL Server Management Studio, if I want to login as sa,
> what is the password for sa ?
> Inside SQL Server Management Studio I changed the password for sa, click
> OK, and when trying to login to SQL Server Management Studio again with sa
> and the password that I just changed it to, it did not let me. It tells me
> "Login failed for user sa. Reason: Not associated with a trusted SQL Serve
r
> connection. Microsoft SQL Server, error: 18452".
> Thank you.
>
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||During installation it did not ask me if I want to use Windows or SQL
Authentication, should it ?
Since I do not know the password for sa, I logged in using Windows
Authentication.
I also posted this in another thread:
when I go to the SQL Server Management Studio and connect to the
Object Explorer and select my Server (there are 2 options for this),
when I select 1 of the server it says SQL Server 8.0.384 and the other
server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
Where is my SQL Server 2005 ?
Thank you.
On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> Are you using Windows or SQL authentication with SQL 2005?
> fniles wrote:
>
>
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email|||You can change that from Management studio if I remember correctly.
Did you select the browse and see if SQL 2005 is listed?
fiefie.niles@.gmail.com wrote:
> During installation it did not ask me if I want to use Windows or SQL
> Authentication, should it ?
> Since I do not know the password for sa, I logged in using Windows
> Authentication.
> I also posted this in another thread:
> when I go to the SQL Server Management Studio and connect to the
> Object Explorer and select my Server (there are 2 options for this),
> when I select 1 of the server it says SQL Server 8.0.384 and the other
> server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
> Where is my SQL Server 2005 ?
> Thank you.
> On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> wrote:
>
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||Thank you.

>You can change that from Management studio if I remember correctly.
Change it to what ?

>Did you select the browse and see if SQL 2005 is listed?
Did you mean browse the "Server Name" ?
When I do that under "Database Engine" there are 2 things listed.
-myComputername\SDK
-myComputername
When I select myComputername\SDK it is SQL Server 8.0.384
When I select myComputername it is SQL Server 8.0.194
Is it possible that I only installed the client portion of the
installation ? I selected everything at installation, and the DVD is
titled "SQL Server 2005 Standard Edition"
On May 19, 9:02 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> You can change that from Management studio if I remember correctly.
> Did you select the browse and see if SQL 2005 is listed?
>
>
> fiefie.ni...@.gmail.com wrote:
>
>
>
>
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email- Hide quoted text -
> - Show quoted text -|||Change the authentication from Windows to SQL
When you start Management Studio you get a short list of SQL Servers.
If you click the arrow you get a list which contains "Browse for more".
Clicking on that lists everything it knows about.
If you selected database engine you should have a server.
fiefie.niles@.gmail.com wrote:
> Thank you.
>
> Change it to what ?
>
> Did you mean browse the "Server Name" ?
> When I do that under "Database Engine" there are 2 things listed.
> -myComputername\SDK
> -myComputername
> When I select myComputername\SDK it is SQL Server 8.0.384
> When I select myComputername it is SQL Server 8.0.194
> Is it possible that I only installed the client portion of the
> installation ? I selected everything at installation, and the DVD is
> titled "SQL Server 2005 Standard Edition"
>
>
> On May 19, 9:02 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> wrote:
>
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||Thanks.
I can't change to SQL Authentication because I do not know the
password for sa. During installation it did not ask me for sa's
password.
When I click the "Browse for more" in the the "Server Name" , under
"Database Engine" there are 2 things listed.
-myComputername\SDK
-myComputername
When I select myComputername\SDK it is SQL Server 8.0.384
When I select myComputername it is SQL Server 8.0.194
None of them is SQL 2005.
During installation I selected all of the following:
1. SQL Server Database Services
2. Analysis Services
3. Reporting Services
4.Notification Services
5. Integration Services
6. Workstation components, books online & development tools
My machine is Win XP Professional SP2.
On May 19, 10:27 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> Change the authentication from Windows to SQL
> When you start Management Studio you get a short list of SQL Servers.
> If you click the arrow you get a list which contains "Browse for more".
> Clicking on that lists everything it knows about.
> If you selected database engine you should have a server.
>
>
> fiefie.ni...@.gmail.com wrote:
>
>
>
>
>
>
>
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email- Hide quoted text -
> - Show quoted text -sql

Question about sa on SQL Server 2005

When installing SQL Server 2005 it never asked me for "sa" password. When
trying to login to SQL Server Management Studio, if I want to login as sa,
what is the password for sa ?
Inside SQL Server Management Studio I changed the password for sa, click
OK, and when trying to login to SQL Server Management Studio again with sa
and the password that I just changed it to, it did not let me. It tells me
"Login failed for user sa. Reason: Not associated with a trusted SQL Server
connection. Microsoft SQL Server, error: 18452".
Thank you.Are you using Windows or SQL authentication with SQL 2005?
fniles wrote:
> When installing SQL Server 2005 it never asked me for "sa" password. When
> trying to login to SQL Server Management Studio, if I want to login as sa,
> what is the password for sa ?
> Inside SQL Server Management Studio I changed the password for sa, click
> OK, and when trying to login to SQL Server Management Studio again with sa
> and the password that I just changed it to, it did not let me. It tells me
> "Login failed for user sa. Reason: Not associated with a trusted SQL Server
> connection. Microsoft SQL Server, error: 18452".
> Thank you.
>
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||During installation it did not ask me if I want to use Windows or SQL
Authentication, should it ?
Since I do not know the password for sa, I logged in using Windows
Authentication.
I also posted this in another thread:
when I go to the SQL Server Management Studio and connect to the
Object Explorer and select my Server (there are 2 options for this),
when I select 1 of the server it says SQL Server 8.0.384 and the other
server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
Where is my SQL Server 2005 ?
Thank you.
On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> Are you using Windows or SQL authentication with SQL 2005?
> fniles wrote:
> > When installing SQL Server 2005 it never asked me for "sa" password. When
> > trying to login to SQL Server Management Studio, if I want to login as sa,
> > what is the password for sa ?
> > Inside SQL Server Management Studio I changed the password for sa, click
> > OK, and when trying to login to SQL Server Management Studio again with sa
> > and the password that I just changed it to, it did not let me. It tells me
> > "Login failed for user sa. Reason: Not associated with a trusted SQL Server
> > connection. Microsoft SQL Server, error: 18452".
> > Thank you.
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email|||You can change that from Management studio if I remember correctly.
Did you select the browse and see if SQL 2005 is listed?
fiefie.niles@.gmail.com wrote:
> During installation it did not ask me if I want to use Windows or SQL
> Authentication, should it ?
> Since I do not know the password for sa, I logged in using Windows
> Authentication.
> I also posted this in another thread:
> when I go to the SQL Server Management Studio and connect to the
> Object Explorer and select my Server (there are 2 options for this),
> when I select 1 of the server it says SQL Server 8.0.384 and the other
> server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
> Where is my SQL Server 2005 ?
> Thank you.
> On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> wrote:
>> Are you using Windows or SQL authentication with SQL 2005?
>> fniles wrote:
>> When installing SQL Server 2005 it never asked me for "sa" password. When
>> trying to login to SQL Server Management Studio, if I want to login as sa,
>> what is the password for sa ?
>> Inside SQL Server Management Studio I changed the password for sa, click
>> OK, and when trying to login to SQL Server Management Studio again with sa
>> and the password that I just changed it to, it did not let me. It tells me
>> "Login failed for user sa. Reason: Not associated with a trusted SQL Server
>> connection. Microsoft SQL Server, error: 18452".
>> Thank you.
>> --
>> Brett I. Holcomb
>> brettholc...@.R777bellsouth.net
>> Remove R777 to email
>
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||Thank you.
>You can change that from Management studio if I remember correctly.
Change it to what ?
>Did you select the browse and see if SQL 2005 is listed?
Did you mean browse the "Server Name" ?
When I do that under "Database Engine" there are 2 things listed.
-myComputername\SDK
-myComputername
When I select myComputername\SDK it is SQL Server 8.0.384
When I select myComputername it is SQL Server 8.0.194
Is it possible that I only installed the client portion of the
installation ? I selected everything at installation, and the DVD is
titled "SQL Server 2005 Standard Edition"
On May 19, 9:02 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> You can change that from Management studio if I remember correctly.
> Did you select the browse and see if SQL 2005 is listed?
>
>
> fiefie.ni...@.gmail.com wrote:
> > During installation it did not ask me if I want to use Windows or SQL
> > Authentication, should it ?
> > Since I do not know the password for sa, I logged in using Windows
> > Authentication.
> > I also posted this in another thread:
> > when I go to the SQL Server Management Studio and connect to the
> > Object Explorer and select my Server (there are 2 options for this),
> > when I select 1 of the server it says SQL Server 8.0.384 and the other
> > server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
> > Where is my SQL Server 2005 ?
> > Thank you.
> > On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> > wrote:
> >> Are you using Windows or SQL authentication with SQL 2005?
> >> fniles wrote:
> >> When installing SQL Server 2005 it never asked me for "sa" password. When
> >> trying to login to SQL Server Management Studio, if I want to login as sa,
> >> what is the password for sa ?
> >> Inside SQL Server Management Studio I changed the password for sa, click
> >> OK, and when trying to login to SQL Server Management Studio again with sa
> >> and the password that I just changed it to, it did not let me. It tells me
> >> "Login failed for user sa. Reason: Not associated with a trusted SQL Server
> >> connection. Microsoft SQL Server, error: 18452".
> >> Thank you.
> >> --
> >> Brett I. Holcomb
> >> brettholc...@.R777bellsouth.net
> >> Remove R777 to email
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email- Hide quoted text -
> - Show quoted text -|||Change the authentication from Windows to SQL
When you start Management Studio you get a short list of SQL Servers.
If you click the arrow you get a list which contains "Browse for more".
Clicking on that lists everything it knows about.
If you selected database engine you should have a server.
fiefie.niles@.gmail.com wrote:
> Thank you.
>> You can change that from Management studio if I remember correctly.
> Change it to what ?
>> Did you select the browse and see if SQL 2005 is listed?
> Did you mean browse the "Server Name" ?
> When I do that under "Database Engine" there are 2 things listed.
> -myComputername\SDK
> -myComputername
> When I select myComputername\SDK it is SQL Server 8.0.384
> When I select myComputername it is SQL Server 8.0.194
> Is it possible that I only installed the client portion of the
> installation ? I selected everything at installation, and the DVD is
> titled "SQL Server 2005 Standard Edition"
>
>
> On May 19, 9:02 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> wrote:
>> You can change that from Management studio if I remember correctly.
>> Did you select the browse and see if SQL 2005 is listed?
>>
>>
>> fiefie.ni...@.gmail.com wrote:
>> During installation it did not ask me if I want to use Windows or SQL
>> Authentication, should it ?
>> Since I do not know the password for sa, I logged in using Windows
>> Authentication.
>> I also posted this in another thread:
>> when I go to the SQL Server Management Studio and connect to the
>> Object Explorer and select my Server (there are 2 options for this),
>> when I select 1 of the server it says SQL Server 8.0.384 and the other
>> server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
>> Where is my SQL Server 2005 ?
>> Thank you.
>> On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
>> wrote:
>> Are you using Windows or SQL authentication with SQL 2005?
>> fniles wrote:
>> When installing SQL Server 2005 it never asked me for "sa" password. When
>> trying to login to SQL Server Management Studio, if I want to login as sa,
>> what is the password for sa ?
>> Inside SQL Server Management Studio I changed the password for sa, click
>> OK, and when trying to login to SQL Server Management Studio again with sa
>> and the password that I just changed it to, it did not let me. It tells me
>> "Login failed for user sa. Reason: Not associated with a trusted SQL Server
>> connection. Microsoft SQL Server, error: 18452".
>> Thank you.
>> --
>> Brett I. Holcomb
>> brettholc...@.R777bellsouth.net
>> Remove R777 to email
>> --
>> Brett I. Holcomb
>> brettholc...@.R777bellsouth.net
>> Remove R777 to email- Hide quoted text -
>> - Show quoted text -
>
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||Thanks.
I can't change to SQL Authentication because I do not know the
password for sa. During installation it did not ask me for sa's
password.
When I click the "Browse for more" in the the "Server Name" , under
"Database Engine" there are 2 things listed.
-myComputername\SDK
-myComputername
When I select myComputername\SDK it is SQL Server 8.0.384
When I select myComputername it is SQL Server 8.0.194
None of them is SQL 2005.
During installation I selected all of the following:
1. SQL Server Database Services
2. Analysis Services
3. Reporting Services
4.Notification Services
5. Integration Services
6. Workstation components, books online & development tools
My machine is Win XP Professional SP2.
On May 19, 10:27 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
wrote:
> Change the authentication from Windows to SQL
> When you start Management Studio you get a short list of SQL Servers.
> If you click the arrow you get a list which contains "Browse for more".
> Clicking on that lists everything it knows about.
> If you selected database engine you should have a server.
>
>
> fiefie.ni...@.gmail.com wrote:
> > Thank you.
> >> You can change that from Management studio if I remember correctly.
> > Change it to what ?
> >> Did you select the browse and see if SQL 2005 is listed?
> > Did you mean browse the "Server Name" ?
> > When I do that under "Database Engine" there are 2 things listed.
> > -myComputername\SDK
> > -myComputername
> > When I select myComputername\SDK it is SQL Server 8.0.384
> > When I select myComputername it is SQL Server 8.0.194
> > Is it possible that I only installed the client portion of the
> > installation ? I selected everything at installation, and the DVD is
> > titled "SQL Server 2005 Standard Edition"
> > On May 19, 9:02 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> > wrote:
> >> You can change that from Management studio if I remember correctly.
> >> Did you select the browse and see if SQL 2005 is listed?
> >> fiefie.ni...@.gmail.com wrote:
> >> During installation it did not ask me if I want to use Windows or SQL
> >> Authentication, should it ?
> >> Since I do not know the password for sa, I logged in using Windows
> >> Authentication.
> >> I also posted this in another thread:
> >> when I go to the SQL Server Management Studio and connect to the
> >> Object Explorer and select my Server (there are 2 options for this),
> >> when I select 1 of the server it says SQL Server 8.0.384 and the other
> >> server it says SQL Server 8.0.194, instead of SQL Server 9.0.xxxx.
> >> Where is my SQL Server 2005 ?
> >> Thank you.
> >> On May 19, 7:16 pm, "Brett I. Holcomb" <brettholc...@.bellsouth.net>
> >> wrote:
> >> Are you using Windows or SQL authentication with SQL 2005?
> >> fniles wrote:
> >> When installing SQL Server 2005 it never asked me for "sa" password. When
> >> trying to login to SQL Server Management Studio, if I want to login as sa,
> >> what is the password for sa ?
> >> Inside SQL Server Management Studio I changed the password for sa, click
> >> OK, and when trying to login to SQL Server Management Studio again with sa
> >> and the password that I just changed it to, it did not let me. It tells me
> >> "Login failed for user sa. Reason: Not associated with a trusted SQL Server
> >> connection. Microsoft SQL Server, error: 18452".
> >> Thank you.
> >> --
> >> Brett I. Holcomb
> >> brettholc...@.R777bellsouth.net
> >> Remove R777 to email
> >> --
> >> Brett I. Holcomb
> >> brettholc...@.R777bellsouth.net
> >> Remove R777 to email- Hide quoted text -
> >> - Show quoted text -
> --
> Brett I. Holcomb
> brettholc...@.R777bellsouth.net
> Remove R777 to email- Hide quoted text -
> - Show quoted text -

question about removing logins at server level

Hi,
I created a login 'Network service' at server level in Management Studio
express.
I use windows authentification.
Then i defined an user for my database which is associated to login 'Network
service', because the application asp.net uses that account (IIS 6.0). This
user received db_read and db_write roles.
This works.
Now i experimented a little bit and i removed from the logins at server
level the login 'Network service'.
Result: the application still works.
.
Then i removed the Builtin\users login from the login list at server level.
Result: i get the error: "login failed for Network service".
I recreated then the login 'Network Service' at server level but not the
Builtin\users login.
Result: it works again.
My conclusion is: one of the two logins must be in the list: Network Service
or Builtin\users
Is this right?
Why do i get that error when both logins are removed and not only when
Network Service is removed?
Thanks
JeanBecause you're using Windows Authentication. From what you described it
doesn't sound like the connection to the db server ever came in using the
Network Service login, but rather came in using Builtin\users.
"Jean" wrote:
> Hi,
> I created a login 'Network service' at server level in Management Studio
> express.
> I use windows authentification.
> Then i defined an user for my database which is associated to login 'Network
> service', because the application asp.net uses that account (IIS 6.0). This
> user received db_read and db_write roles.
> This works.
> Now i experimented a little bit and i removed from the logins at server
> level the login 'Network service'.
> Result: the application still works.
> ..
> Then i removed the Builtin\users login from the login list at server level.
> Result: i get the error: "login failed for Network service".
> I recreated then the login 'Network Service' at server level but not the
> Builtin\users login.
> Result: it works again.
> My conclusion is: one of the two logins must be in the list: Network Service
> or Builtin\users
> Is this right?
> Why do i get that error when both logins are removed and not only when
> Network Service is removed?
> Thanks
> Jean
>
>|||Thanks, but after deleting the login Network Service, the user still is
mapped to Network Service account, no? If i delete that user, then the
application fails.
"Hurme" <michael.geles@.thomson.com> schreef in bericht
news:1F40DC8A-A258-4900-BD8B-1B312F151ED4@.microsoft.com...
> Because you're using Windows Authentication. From what you described it
> doesn't sound like the connection to the db server ever came in using the
> Network Service login, but rather came in using Builtin\users.
>
> "Jean" wrote:
>> Hi,
>> I created a login 'Network service' at server level in Management Studio
>> express.
>> I use windows authentification.
>> Then i defined an user for my database which is associated to login
>> 'Network
>> service', because the application asp.net uses that account (IIS 6.0).
>> This
>> user received db_read and db_write roles.
>> This works.
>> Now i experimented a little bit and i removed from the logins at server
>> level the login 'Network service'.
>> Result: the application still works.
>> ..
>> Then i removed the Builtin\users login from the login list at server
>> level.
>> Result: i get the error: "login failed for Network service".
>> I recreated then the login 'Network Service' at server level but not the
>> Builtin\users login.
>> Result: it works again.
>> My conclusion is: one of the two logins must be in the list: Network
>> Service
>> or Builtin\users
>> Is this right?
>> Why do i get that error when both logins are removed and not only when
>> Network Service is removed?
>> Thanks
>> Jean
>>|||I'm not sure about whether or not the Network Service id would still be
mapped or not, but I just did a test on one of my sql servers. I previously
did not have the BUILTIN\Users login and tried to login with a domain account
login that did not exist on the sql server nor the windows 2003 server. When
I tried to login access was denied. Once I created the BUILTIN\Users login on
hte sql server I was able to get in.
"Jean" wrote:
> Thanks, but after deleting the login Network Service, the user still is
> mapped to Network Service account, no? If i delete that user, then the
> application fails.
> "Hurme" <michael.geles@.thomson.com> schreef in bericht
> news:1F40DC8A-A258-4900-BD8B-1B312F151ED4@.microsoft.com...
> > Because you're using Windows Authentication. From what you described it
> > doesn't sound like the connection to the db server ever came in using the
> > Network Service login, but rather came in using Builtin\users.
> >
> >
> >
> > "Jean" wrote:
> >
> >> Hi,
> >>
> >> I created a login 'Network service' at server level in Management Studio
> >> express.
> >> I use windows authentification.
> >> Then i defined an user for my database which is associated to login
> >> 'Network
> >> service', because the application asp.net uses that account (IIS 6.0).
> >> This
> >> user received db_read and db_write roles.
> >>
> >> This works.
> >>
> >> Now i experimented a little bit and i removed from the logins at server
> >> level the login 'Network service'.
> >> Result: the application still works.
> >> ..
> >> Then i removed the Builtin\users login from the login list at server
> >> level.
> >> Result: i get the error: "login failed for Network service".
> >>
> >> I recreated then the login 'Network Service' at server level but not the
> >> Builtin\users login.
> >> Result: it works again.
> >>
> >> My conclusion is: one of the two logins must be in the list: Network
> >> Service
> >> or Builtin\users
> >>
> >> Is this right?
> >> Why do i get that error when both logins are removed and not only when
> >> Network Service is removed?
> >>
> >> Thanks
> >> Jean
> >>
> >>
> >>
>
>|||Ok, thanks
"Hurme" <michael.geles@.thomson.com> schreef in bericht
news:6D07EA51-00F3-4787-91A8-95C6BF5C2B4C@.microsoft.com...
> I'm not sure about whether or not the Network Service id would still be
> mapped or not, but I just did a test on one of my sql servers. I
> previously
> did not have the BUILTIN\Users login and tried to login with a domain
> account
> login that did not exist on the sql server nor the windows 2003 server.
> When
> I tried to login access was denied. Once I created the BUILTIN\Users login
> on
> hte sql server I was able to get in.
>
> "Jean" wrote:
>> Thanks, but after deleting the login Network Service, the user still is
>> mapped to Network Service account, no? If i delete that user, then the
>> application fails.
>> "Hurme" <michael.geles@.thomson.com> schreef in bericht
>> news:1F40DC8A-A258-4900-BD8B-1B312F151ED4@.microsoft.com...
>> > Because you're using Windows Authentication. From what you described
>> > it
>> > doesn't sound like the connection to the db server ever came in using
>> > the
>> > Network Service login, but rather came in using Builtin\users.
>> >
>> >
>> >
>> > "Jean" wrote:
>> >
>> >> Hi,
>> >>
>> >> I created a login 'Network service' at server level in Management
>> >> Studio
>> >> express.
>> >> I use windows authentification.
>> >> Then i defined an user for my database which is associated to login
>> >> 'Network
>> >> service', because the application asp.net uses that account (IIS 6.0).
>> >> This
>> >> user received db_read and db_write roles.
>> >>
>> >> This works.
>> >>
>> >> Now i experimented a little bit and i removed from the logins at
>> >> server
>> >> level the login 'Network service'.
>> >> Result: the application still works.
>> >> ..
>> >> Then i removed the Builtin\users login from the login list at server
>> >> level.
>> >> Result: i get the error: "login failed for Network service".
>> >>
>> >> I recreated then the login 'Network Service' at server level but not
>> >> the
>> >> Builtin\users login.
>> >> Result: it works again.
>> >>
>> >> My conclusion is: one of the two logins must be in the list: Network
>> >> Service
>> >> or Builtin\users
>> >>
>> >> Is this right?
>> >> Why do i get that error when both logins are removed and not only when
>> >> Network Service is removed?
>> >>
>> >> Thanks
>> >> Jean
>> >>
>> >>
>> >>
>>

question about master system database

Hi, i use sql server 2005 express where i created several databases. When opening Management Studio, i can see, besides my databases, also Master, Model etc .. which manage the databases. Now i also use MDF files which are disseminated on the same server. I see that for one given user, there is also a Master, Model etc ... in c:\document and settings\that user\ ....

My question is: are those local Master, Model etc ... related with the central Master, Model ... of the central database system or are they independant? What if i delete the MDF files and its related system files in c:\.doc and settings\.. ?

Thanks

When you check under properties for the database in the Management Studio you should see the database is pointing to a particular file on the drives. So other than this MDF file you could delete any other MDF files with same name if you are sure no one else is using the files. You could try moving the files to a different location and if it lets you do it then no one is using it. If the files are being used you would get an '..Access violation..' or ' file in use..' error.

|||thanks

question about IIS Virtual Directory Management for MS SQL server 2000

Hi,

I installed the MS SQL Server 2000 trial version in my computer. The Operating System is WinXP. It seems everything is OK, the MSSQLserver is running after I restart the computer.

Then I tried to create a few virtual directories following these steps:
Choose start => programs => Microsoft SQL server => Configure SQL XML Support in IIS

What I can see is the icon " IIS virtual Directory Management for SQL Server" in the left pane, and nothing in the right pane. Is this normal?

I right clicked the icon, selected the "connect", typed in the computer name as it required. But it showed that an error occurred connecting to the computer. The reason is "this server does not exist or is unavailable". It is quite strange that actually the SQL server is running at this time.

Is there anybody who can tell me what 's wrong with it? Do I have to do some special configuration?

Thanks a lot

Johnwhen u see this icon: IIS virtual Directory Management for SQL Server

click it, at least you should see the computer where the sql server is intalled in right pane. then u can drill down to see the default web site.

if nothing ... try to connect to the computer ur got sql server installed. make sure u have installed IIS.

if still cant, dont know whether it has anything to do with the trial version. i am using personal edition, and everything is fine.|||Thanks.

I made a stupid mistake. I didn't install IIS. :-(