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 -
Showing posts with label password. Show all posts
Showing posts with label password. Show all posts
Friday, March 30, 2012
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
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 -
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 RS2k user logon window
When I'm trying to logon the reporting service main page, the user logon dialogue box will ask you to input the authorized user id and password(It's the account created in windows system). But when I try to open certain report!on my reporting server, this logon dialogue box will be displayed again and I have to input the account and password again. All the reports can be directly opened after second entry.
So my quesition is how to setup reporting service so that I can open all the reports directly just after the first entry.That will bother users to browse report!freely only after inputing authority information twice.
PS: My platform is Windows 2K Server SP4 + SQL Server 2K SP4.
Thats because you first contact the Reporting Server (localhot/reports) and the afterwards the localhost/reportserver Webservice. Seems that you configured it for integrated authentication and did not setup the Windows client to pass user credentials automatically or did setup the client to use basic authentication instead of integrated Wndows Authentication.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||Thanks,Suessmeyer. Where can I setup the Windows client to pass user credentials automatically ?|||Does anybody know the answer?|||
Ok,I've solved problem. That's because I use domain name to logon my reporting server like this format: http://www.xxxx.com/reports, but I've setup the IP address in the reportmanager configuration file RSWebApplication.config to access the reportserver :<ReportServerUrl>http://220.xxx.xxx.xxx/ReportServer</ReportServerUrl>.
So the first time when I logon to the report!manager, it poped up a logon window with domain name and user account like this format: www.xxxx.com/rptuser, then after I clicked certain report, it pointed to the report!server and asked you to logon with this account: 220.xxx.xxx.xxx/rptuser . I've changed my ReportServerUrl setup to domain name then the problem is solved.
Question about RS2k user logon window
When I'm trying to logon the reporting service main page, the user logon dialogue box will ask you to input the authorized user id and password(It's the account created in windows system). But when I try to open certain report!on my reporting server, this logon dialogue box will be displayed again and I have to input the account and password again. All the reports can be directly opened after second entry.
So my quesition is how to setup reporting service so that I can open all the reports directly just after the first entry.That will bother users to browse report!freely only after inputing authority information twice.
PS: My platform is Windows 2K Server SP4 + SQL Server 2K SP4.
Thats because you first contact the Reporting Server (localhot/reports) and the afterwards the localhost/reportserver Webservice. Seems that you configured it for integrated authentication and did not setup the Windows client to pass user credentials automatically or did setup the client to use basic authentication instead of integrated Wndows Authentication.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Thanks,Suessmeyer. Where can I setup the Windows client to pass user credentials automatically ?|||Does anybody know the answer?|||
Ok,I've solved problem. That's because I use domain name to logon my reporting server like this format: http://www.xxxx.com/reports, but I've setup the IP address in the reportmanager configuration file RSWebApplication.config to access the reportserver :<ReportServerUrl>http://220.xxx.xxx.xxx/ReportServer</ReportServerUrl>.
So the first time when I logon to the report!manager, it poped up a logon window with domain name and user account like this format: www.xxxx.com/rptuser, then after I clicked certain report, it pointed to the report!server and asked you to logon with this account: 220.xxx.xxx.xxx/rptuser . I've changed my ReportServerUrl setup to domain name then the problem is solved.
|||edward barry date of birth 04-12-1968
city villa park il I work for school district45in dupagecounty i'm janitor work phone 630 953-8192Monday, March 12, 2012
Question about encryption and password protection
Howdy!
Couple quick questions:
1) How much does setting encryption cost in terms of speed of querying and cpu usage?
2) If encryption is not set, is the password "encrypted" when its sent with the initialization routine?
Thanks in advance!
1: Most agree on a 10 - 20 % performance hit (on devices), it is probably not noticeable on a desktop.
2: If a password is specifed, you are always using encryption
Password-or-Pwd-or-database password-or-ssce
atabase password
The database password, which can be up to 40 characters in length. If not specified, the default value is no password. This property is required if you enable encryption on the database. If you specify a password, encryption is automatically enabled on the database.
|||Thanks for the reply!
Monday, February 20, 2012
Question
In SqlServer, What is the datatype to mask a field of a table ? I mean if I want to save a password in a table, entering to SQLServer I'd want to display "*****" instead of "hello".
Thanks...
There are HTML, .NET, and Win32 controls that can be used to mask user input as they're entering some sensitive data in your application.
If, however, you want to ensure that users can't query your database for the names and passwords of all of the other users of the database, then you'll want to use any of a variety of permissions on your database.
For instance, if some operation is being done on the user's behalf, you could control the permissions on a table containing sensitive data to allow only indirect access (e.g. allow a server process to insert, update, delete from the table on the user's behalf, but disallow direct manipulation of the underlying table by the user). This obviously requires some form of strong and reliable user authentication.
You could also use row and/or column level permissions to control the amount of data that a user is able to see. For example, row level security (applied correctly) would allow everyone to perform a SELECT username, password FROM users and only see the data from rows that they had specifically been given access to.
There is lots of good documentation on establishing permissions on securables (tables, views, columns, etc.) in the SQL Server Books Online. There is also an excellent article on this subject at: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx
Subscribe to:
Posts (Atom)