|
Home > Archive > MS SQL Server security > February 2006 > how to associate sql login with a trusted sql server connection?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to associate sql login with a trusted sql server connection?
|
|
|
| Hello,
Last night I loaded a 2nd instance (development instance) of sql server on
my server machine (win2003). The first instance is the local server - serv1.
The 2nd instance is serv1\dev. I loaded both instances using Windows
authentication. Note: the first instance was loaded on the default port of
1433. But for the 2nd instance, Setup assigned a default port of 0. I went
with port 0 and windows authentication. When I connect to serv1\dev in Query
Analyzer through Windows authentication I connect OK. But I added a sql
login to serv1\dev. I can't connect to serv1\dev from Query Analyzer using
my sql login. The error message says that the login failed because my login
is not associated with a trusted sql server connection. So how do I
associate my sql login with a trusted sql server connection?
Note: On the original install I also added a sql login, and it works fine
from the server computer and from remote workstations. Why did the serv1
login work but not my new login on serv1\dev?
Thanks,
Rich
| |
|
| After doing a little research, I believe my problem is that I loaded
serv1\dev instance of sql server with Windows Authentication where I should
have selected Sql Authentication. When I register serv1\dev I can only
register it using Windows Authentication. Once the server is registered I go
into Edit Registration and select Sql authentication but it won't take
because my sql login is not associated with a trusted connection. Is there a
way around this? Or do I need to re-install this instance?
"Rich" wrote:
> Hello,
>
> Last night I loaded a 2nd instance (development instance) of sql server on
> my server machine (win2003). The first instance is the local server - serv1.
> The 2nd instance is serv1\dev. I loaded both instances using Windows
> authentication. Note: the first instance was loaded on the default port of
> 1433. But for the 2nd instance, Setup assigned a default port of 0. I went
> with port 0 and windows authentication. When I connect to serv1\dev in Query
> Analyzer through Windows authentication I connect OK. But I added a sql
> login to serv1\dev. I can't connect to serv1\dev from Query Analyzer using
> my sql login. The error message says that the login failed because my login
> is not associated with a trusted sql server connection. So how do I
> associate my sql login with a trusted sql server connection?
>
> Note: On the original install I also added a sql login, and it works fine
> from the server computer and from remote workstations. Why did the serv1
> login work but not my new login on serv1\dev?
>
> Thanks,
> Rich
| |
|
| OK. I figured out the problem. I had to go into the serv1\dev server
properties and click on the "Sql and Windows Authentication" option. Now I
can connect using my sql login
"Rich" wrote:
> Hello,
>
> Last night I loaded a 2nd instance (development instance) of sql server on
> my server machine (win2003). The first instance is the local server - serv1.
> The 2nd instance is serv1\dev. I loaded both instances using Windows
> authentication. Note: the first instance was loaded on the default port of
> 1433. But for the 2nd instance, Setup assigned a default port of 0. I went
> with port 0 and windows authentication. When I connect to serv1\dev in Query
> Analyzer through Windows authentication I connect OK. But I added a sql
> login to serv1\dev. I can't connect to serv1\dev from Query Analyzer using
> my sql login. The error message says that the login failed because my login
> is not associated with a trusted sql server connection. So how do I
> associate my sql login with a trusted sql server connection?
>
> Note: On the original install I also added a sql login, and it works fine
> from the server computer and from remote workstations. Why did the serv1
> login work but not my new login on serv1\dev?
>
> Thanks,
> Rich
|
|
|
|
|