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 Reporting Services...

I used Visual Studio 2003 to create several reports and those reports are
saved to a virtual directory at the IIS server. At present I can only open
those reports using the Report Manager came with the Reporting Services. I
wonder if I can open those reports straight from the web site with a
hyperlink and without opening the Report ManagerUI. If it is the case how
dose it work to connect to the SQL database? My understanding is the
connection/other information associated with the report is saved in a table
"Report Server" at the SQL database. Can I attach this connection string
information in a file at IIS or can it be attached right to the report
itself? Also how will it work in printing those reports in different file
formats as shown in the Reporting Manager if I allow to by-pass using the
Report Manager UI? Thank you for your infor.Hi Paul,
I assume when you mean "open" reports, you mean you want to retrieve a rendered
copy of the report (not retrieve the report definition, etc).
You can access the reports by URL quite easily. If say you have a report
"Purchase Order" in the folder "Demos" (/Demos/Purchase Order). Use this
URL:
http://<yourServer>/ReportServer/?/Demos/Purchase+Order
Then you can attach various URL parameters to control what happens. To render
the report in PDF, use this URL:
http://<yourServer>/ReportServer/?/Demos/Purchase+Order&rs:Command=Render&rs:Format=PDF
All of the database connection information is either stored in the RDL file
on the server, or as part of a Shared Data Source. So, there's no need to
send that info through the URL. If you have additional report parameters,
append them like you would any other URL querystring value. For example,
if you have a parameter "SalesYear":
http://<yourServer>/ReportServer/?/Demos/Purchase+Order&rs:Command=Render&rs:Format=PDF&SalesYear=2005
You can also use the RS web-services API:
http://support.microsoft.com/?kbid=875447
I've always thought that this was the way MSFT intended for users to get
to reports... built seamlessly into web applications, while Report Manager
was for report management/administration.
-Chris @. SoftArtisans
> I used Visual Studio 2003 to create several reports and those reports
> are saved to a virtual directory at the IIS server. At present I can
> only open those reports using the Report Manager came with the
> Reporting Services. I wonder if I can open those reports straight from
> the web site with a hyperlink and without opening the Report
> ManagerUI. If it is the case how dose it work to connect to the SQL
> database? My understanding is the connection/other information
> associated with the report is saved in a table "Report Server" at the
> SQL database. Can I attach this connection string information in a
> file at IIS or can it be attached right to the report itself? Also how
> will it work in printing those reports in different file formats as
> shown in the Reporting Manager if I allow to by-pass using the Report
> Manager UI? Thank you for your infor.
>

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 Aggragation in Measure Group?

Hello,

I am working on a project using SQL Server BI Developement Studio 2005. While designing a cube, I would like create a Measure Group that shows me a count of students grouped by department or school. However, I am not able to see an aggragate function under Measure Group's properties that would take care of this? For a while I was thinking about using "ByAccount" function but my dimension doesn't have anything called Account. My dimension has following columns: studentid, term, majorid, [dept id], [dept name], [school id], [school name]. Is there a way to get a count of students grouped by dept or school under a Measure Group?

Thanks,

Below, you can see functions that I am able to see when designing Meaure Groups.

Sum

Count

Min

Max

DistinctCount

None

ByAccount

AverageOfChildren

FirstChild

LastChild

FirstNonEmpty

LastNonEmpty

Hi,

I suspect that you might didn't understand the concept of OLAP yet (sorry if I'm wrong with that assumption).

You first have to think about your data... what are facts, what are dimensions. Facts are the base of your measures. Dimensions are your grouping creterias.

In your case the fact table and the dimension table might be the same. You define a "count" measure on any of your fields.

You also define one or more dimensions with your grouping creterias (department, school or whatever you want)...

When you open your cube you will see the count of records you processed. You then can drilldown on each dimension you defined to group your count...

Sorry, this is only a very brief hint how you might start. I really can't give you a complete training on OLAP in this forum...

|||

Thank you Thomas. I am new to Olap and still struggling a little bit to get the concepts right. My understading of a Fact table was that it was the only place where you have columns that can be summed, addded ,aggragated and so on. However, it looks like it is not the case. Do you know where I could learn more about BI in SQL 2005? Is there a website or something with some info?

|||

Take a look for Mosha & Teo Lachev on Google.

Mosha has some good resources listed on his web site. Teo has a great book out.

Question about Aggragation in Measure Group?

Hello,

I am working on a project using SQL Server BI Developement Studio 2005. While designing a cube, I would like create a Measure Group that shows me a count of students grouped by department or school. However, I am not able to see an aggragate function under Measure Group's properties that would take care of this? For a while I was thinking about using "ByAccount" function but my dimension doesn't have anything called Account. My dimension has following columns: studentid, term, majorid, [dept id], [dept name], [school id], [school name]. Is there a way to get a count of students grouped by dept or school under a Measure Group?

Thanks,

Below, you can see functions that I am able to see when designing Meaure Groups.

Sum

Count

Min

Max

DistinctCount

None

ByAccount

AverageOfChildren

FirstChild

LastChild

FirstNonEmpty

LastNonEmpty

Hi,

I suspect that you might didn't understand the concept of OLAP yet (sorry if I'm wrong with that assumption).

You first have to think about your data... what are facts, what are dimensions. Facts are the base of your measures. Dimensions are your grouping creterias.

In your case the fact table and the dimension table might be the same. You define a "count" measure on any of your fields.

You also define one or more dimensions with your grouping creterias (department, school or whatever you want)...

When you open your cube you will see the count of records you processed. You then can drilldown on each dimension you defined to group your count...

Sorry, this is only a very brief hint how you might start. I really can't give you a complete training on OLAP in this forum...

|||

Thank you Thomas. I am new to Olap and still struggling a little bit to get the concepts right. My understading of a Fact table was that it was the only place where you have columns that can be summed, addded ,aggragated and so on. However, it looks like it is not the case. Do you know where I could learn more about BI in SQL 2005? Is there a website or something with some info?

|||

Take a look for Mosha & Teo Lachev on Google.

Mosha has some good resources listed on his web site. Teo has a great book out.

Question - I think it has got to do with grouping (although not su

Hello,
I have created a list in visual studio reporting services with all
outstanding invoices for a range of customers (where customer number between
'From' and 'To' parameter). I have also created a statement in the reporting
layout, but now I would like to know I can make sure that the statement for
every customer appears on a new page?
Statement looks as follows:
---
Customer number: XXXXXXXXXX
Customer name: John Doe
Adress: Test street 23
...
======= Invoice details (this is a table which contains all outstanding invoices for
this customer including the open amounts).
Please help.
Thanks!
CheersOn Jan 10, 3:19 am, DHL <D...@.discussions.microsoft.com> wrote:
> Hello,
> I have created a list in visual studio reporting services with all
> outstanding invoices for a range of customers (where customer number between
> 'From' and 'To' parameter). I have also created a statement in the reporting
> layout, but now I would like to know I can make sure that the statement for
> every customer appears on a new page?
> Statement looks as follows:
> ---
> Customer number: XXXXXXXXXX
> Customer name: John Doe
> Adress: Test street 23
> ...
> =======> Invoice details (this is a table which contains all outstanding invoices for
> this customer including the open amounts).
> Please help.
> Thanks!
> Cheers
You would set your Group properties to 'Page break at end.' You would
do this via: right-clicking the table/matrix control >> select
Properties >> select Groups tab >> select the Edit... button >> then
select 'Page break at end.' Hope this helps.
Regards,
Enrique Martinez
Sr Software Consultant