connection failed... not associated with a trusted SQL Server connection

Using Query Analyser, I cannot log in using the SQL 'sa' user name and
password. I get an error saying "connection failed... not associated with a
trusted SQL Server connection" When and where can the 'sa' credential be
used without creating this error?
thanks,
KeithHi,
Change the authentication mode to Windows and SQL server and try connecting
using SA.
How to change:-
1. In Enterprise Manager -- Expand the Server
2. Right click on the server name and select propertirs
3. Choose the security Tab and select SQL Server and Windows
4. Click ok and restart the windows service.
Thanks
hari
SQL Server MVP
"keithb" <k31thb@.yahoo.com> wrote in message
news:utbk$LIuFHA.3740@.TK2MSFTNGP14.phx.gbl...
> Using Query Analyser, I cannot log in using the SQL 'sa' user name and
> password. I get an error saying "connection failed... not associated with
> a trusted SQL Server connection" When and where can the 'sa' credential be
> used without creating this error?
> thanks,
> Keith
>

connection failed... not associated with a trusted SQL Server connection

Using Query Analyser, I cannot log in using the SQL 'sa' user name and
password. I get an error saying "connection failed... not associated with a
trusted SQL Server connection" When and where can the 'sa' credential be
used without creating this error?
thanks,
Keith
Hi,
Change the authentication mode to Windows and SQL server and try connecting
using SA.
How to change:-
1. In Enterprise Manager -- Expand the Server
2. Right click on the server name and select propertirs
3. Choose the security Tab and select SQL Server and Windows
4. Click ok and restart the windows service.
Thanks
hari
SQL Server MVP
"keithb" <k31thb@.yahoo.com> wrote in message
news:utbk$LIuFHA.3740@.TK2MSFTNGP14.phx.gbl...
> Using Query Analyser, I cannot log in using the SQL 'sa' user name and
> password. I get an error saying "connection failed... not associated with
> a trusted SQL Server connection" When and where can the 'sa' credential be
> used without creating this error?
> thanks,
> Keith
>

Connection failed error during upsizing of an Access database to SQl Server Express databa

Hello,
In order to utilize an Access database as SQL Server database I use
Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
wait I get the following error:
Connection failed:
SQL State:'01000'
SQL error Error:2
[Microsoft][ODBC Server Driver][Shared
Memory]ConnectionOpen(Connect())
Connection Failed:
SQL State:'08001'
SQL server Error:17
[Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
exist or access is denied
Under VS2008 I can connect to Northwind SQLServer Express database and
manipulate the data OK. So what can I do? Thank you.
Athena
Hello,
I found what's wrong. Server name comes by default as (local) I changed
to right one. It worked.
Athena
"Athena" <Nospam@.nospam.com> wrote in message
news:4616FCF7-A008-4D57-9FBE-480455B4E162@.microsoft.com...
> Hello,
> In order to utilize an Access database as SQL Server database I use
> Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
> wait I get the following error:
> Connection failed:
> SQL State:'01000'
> SQL error Error:2
> [Microsoft][ODBC Server Driver][Shared
> Memory]ConnectionOpen(Connect())
> Connection Failed:
> SQL State:'08001'
> SQL server Error:17
> [Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
> exist or access is denied
> Under VS2008 I can connect to Northwind SQLServer Express database and
> manipulate the data OK. So what can I do? Thank you.
> Athena

Connection between two domains

Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same pass
word) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and the
y
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:

> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domai
n.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:

> I believe that your only option is to create the same account (and same pa
ssword) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>

Connection between two domains

Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same password) in both domains.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and
> > they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>> Hi,
>> You can try doing a Run As ...
>> Shift + Right Click on EM shortcut and select Run As ...
>> Enter your other domain user credentials in the form:
>> domain\username
>> password
>> I'm not 100% sure that this will work though. Is your computer a member
>> of
>> both domains?
>> It will somehow have to authenticate your credentials with the other
>> domain.
>> --
>> HTH
>> Dan Artuso
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>> > Hi All,
>> >
>> > We have two different domains in our environment, say ABC and XYZ, and
>> > they
>> > are not trusted. I login into my PC using ABC domain .
>> >
>> > I have windows authenticated login in SQLServer that is in XYZ domain.
>> >
>> > Can anyone tell me how I can connect to SQL server that is in different
>> > domain using Enterprise Manager or query analyzer?
>> >
>> > Thanks,
>> > Vinod
>> >
>>

Connection between two domains

Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
Vinod
Hi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||I believe that your only option is to create the same account (and same password) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:

> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>
|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:

> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:

Connection : trusted

Hi all, in one of my newly configured SQL server logs, I found a error
message like this:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
Also in both of my new servers , SQL server logs following message repeated
all the time with differefnt date.
Login succeeded for user 'domain\user1'. Connection: Trusted.
And I couldn't find any similar log messages from the current production
server.
Any ideas? did I do something wrong when I set up new servers?
Thanks a lot.
Your server is not configures for mixed authentication, that why he is
accepting domain users but not the SQL Users:
http://msdn.microsoft.com/library/de...urity_47u6.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> Hi all, in one of my newly configured SQL server logs, I found a error
> message like this:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.
> Also in both of my new servers , SQL server logs following message
> repeated
> all the time with differefnt date.
> Login succeeded for user 'domain\user1'. Connection: Trusted.
> And I couldn't find any similar log messages from the current production
> server.
> Any ideas? did I do something wrong when I set up new servers?
> Thanks a lot.
|||thanks. But my production server is using the same authentication, why I did
not see the same logs messages?
"Jens Sü?meyer" wrote:

> Your server is not configures for mixed authentication, that why he is
> accepting domain users but not the SQL Users:
> http://msdn.microsoft.com/library/de...urity_47u6.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
>
>
|||Then you have not set the same security options for the new server.
Apparently one of the servers is set to audit all login attempts, the other
is set to audit successful logins.
|||You are right, I set different audit trace for the two servers, but I how can
I find if I set to log successful logins ?
Thanks a lot!
"Scott Morris" wrote:

> Then you have not set the same security options for the new server.
> Apparently one of the servers is set to audit all login attempts, the other
> is set to audit successful logins.
>
>
|||Documentation? BOL -> Search -> "login failure"
|||Thnaks, I found it.
"Scott Morris" wrote:

> Documentation? BOL -> Search -> "login failure"
>
>

Connection : trusted

Hi all, in one of my newly configured SQL server logs, I found a error
message like this:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
Also in both of my new servers , SQL server logs following message repeated
all the time with differefnt date.
Login succeeded for user 'domain\user1'. Connection: Trusted.
And I couldn't find any similar log messages from the current production
server.
Any ideas? did I do something wrong when I set up new servers?
Thanks a lot.Your server is not configures for mixed authentication, that why he is
accepting domain users but not the SQL Users:
http://msdn.microsoft.com/library/d...>
ity_47u6.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> Hi all, in one of my newly configured SQL server logs, I found a error
> message like this:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.
> Also in both of my new servers , SQL server logs following message
> repeated
> all the time with differefnt date.
> Login succeeded for user 'domain\user1'. Connection: Trusted.
> And I couldn't find any similar log messages from the current production
> server.
> Any ideas? did I do something wrong when I set up new servers?
> Thanks a lot.|||thanks. But my production server is using the same authentication, why I did
not see the same logs messages?
"Jens Sü?meyer" wrote:

> Your server is not configures for mixed authentication, that why he is
> accepting domain users but not the SQL Users:
> http://msdn.microsoft.com/library/d...
urity_47u6.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
>
>|||Then you have not set the same security options for the new server.
Apparently one of the servers is set to audit all login attempts, the other
is set to audit successful logins.|||You are right, I set different audit trace for the two servers, but I how ca
n
I find if I set to log successful logins '
Thanks a lot!
"Scott Morris" wrote:

> Then you have not set the same security options for the new server.
> Apparently one of the servers is set to audit all login attempts, the othe
r
> is set to audit successful logins.
>
>|||Documentation? BOL -> Search -> "login failure"|||Thnaks, I found it.
"Scott Morris" wrote:

> Documentation? BOL -> Search -> "login failure"
>
>

Connection : trusted

Hi all, in one of my newly configured SQL server logs, I found a error
message like this:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
Also in both of my new servers , SQL server logs following message repeated
all the time with differefnt date.
Login succeeded for user 'domain\user1'. Connection: Trusted.
And I couldn't find any similar log messages from the current production
server.
Any ideas? did I do something wrong when I set up new servers?
Thanks a lot.Your server is not configures for mixed authentication, that why he is
accepting domain users but not the SQL Users:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> Hi all, in one of my newly configured SQL server logs, I found a error
> message like this:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.
> Also in both of my new servers , SQL server logs following message
> repeated
> all the time with differefnt date.
> Login succeeded for user 'domain\user1'. Connection: Trusted.
> And I couldn't find any similar log messages from the current production
> server.
> Any ideas? did I do something wrong when I set up new servers?
> Thanks a lot.|||thanks. But my production server is using the same authentication, why I did
not see the same logs messages?
"Jens Sü�meyer" wrote:
> Your server is not configures for mixed authentication, that why he is
> accepting domain users but not the SQL Users:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> > Hi all, in one of my newly configured SQL server logs, I found a error
> > message like this:
> > Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> > Server
> > connection.
> >
> > Also in both of my new servers , SQL server logs following message
> > repeated
> > all the time with differefnt date.
> >
> > Login succeeded for user 'domain\user1'. Connection: Trusted.
> >
> > And I couldn't find any similar log messages from the current production
> > server.
> > Any ideas? did I do something wrong when I set up new servers?
> >
> > Thanks a lot.
>
>|||Then you have not set the same security options for the new server.
Apparently one of the servers is set to audit all login attempts, the other
is set to audit successful logins.|||You are right, I set different audit trace for the two servers, but I how can
I find if I set to log successful logins '
Thanks a lot!
"Scott Morris" wrote:
> Then you have not set the same security options for the new server.
> Apparently one of the servers is set to audit all login attempts, the other
> is set to audit successful logins.
>
>|||Documentation? BOL -> Search -> "login failure"|||Thnaks, I found it.
"Scott Morris" wrote:
> Documentation? BOL -> Search -> "login failure"
>
>

Connection

Hi I'm George and I have a problem wich I can't solve:
when I install a CMS wich uses MSDE il get the Message this is not a trusted
SQLConnection..blablabla...
What can I do ' Please help me.George wrote:
> Hi I'm George and I have a problem wich I can't solve:
> when I install a CMS wich uses MSDE il get the Message this is not a
> trusted SQLConnection..blablabla...
> What can I do ' Please help me.
You can add your local Windows login or Domain Login to SQL Server. To
do this, run SQL Enterprise Manager and add a new login and map it to
the domain/Windows login (under the Security node).
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

connecting using a trusted connection

Hello,

I appologize if this is in the wrong spot, but it seemed like the appropriate place.

We have IIS installed on one box and SQL on another. We use a trusted connection to connect.

When we try an connect to our DB, we don't get an error, the page just refreshes. From what i have gathered, it looks like we are not being authenticated. We have the ASPNET domain user on both boxes and its configured with the correct permissions, but we still can't connect.

Do i need to set up or give permissions to another account i dont know about, or is there some file that needs access?

Have you checked SQL logs, or IIS logs? Event logs? If it's a securtiy issue it should be logged. Also make sure you really are using the ASP.NET account when you access the box, it could be an authenticated user's credentials that are passed. And keep in mind that by defualt the ASp.NET process account is not a domain account, it's local.

Jeff

|||There are two permissions in SQL Server, the server permissions in the management section of Enterprise Manager or Management Studio and the database permissions are in the database under permissions and in SQL Server 2005 under security in the database. You may have created one and not the other. Hope this helps.

Connecting to SQL Server 2k using Thin drivers

Hi all,
I am new to java. I need to write an applet which takes input from user and
updates the database. I wrote a trusted applet but i was unable to access
network resources. Then i wrote thread inside an apllet which is working fine.
When I use JDBC-ODBC driver, its taking DSN from client machine and not from
server. Can i specify Server DSN?
When I use Thin Drivers, I am getting ClassNotFoundException in the
following line
Driver d =
(Driver)Class.forName("com.microsoft.jdbc.sqlserve r.SQLServerDriver").newInstance();
Here is my code, please let me know if anything is wrong
try {
Driver d =
(Driver)Class.forName("com.microsoft.jdbc.sqlserve r.SQLServerDriver").newInstance();
con =
DriverManager.getConnection("jdbc:microsoft:sqlser ver://wks01:1433";User=test;Password=pass");
}
catch(ClassNotFoundException e) { e.printStackTrace();}
catch(Exception e){ e.printStackTrace();}
finally {
try {
Statement stmt = con.createStatement();
stmt.executeUpdate("INSERT INTO lms " + "VALUES ('" + NewApplet.this.lmsVar
+ "')");
if(con != null)
con.close();
}
catch(Exception e) { }
}
Also, If i specify Database Server name as Server name will it resolve from
client
| Thread-Topic: Connecting to SQL Server 2k using Thin drivers
| thread-index: AcS2s/k6uARnoX50RGqx7t2nvEPbgw==
| X-WBNR-Posting-Host: 203.197.255.91
| From: "=?Utf-8?B?VWp3YWwgQyBSZWRkeQ==?=" <Ujwal C
Reddy@.discussions.microsoft.com>
| Subject: Connecting to SQL Server 2k using Thin drivers
| Date: Wed, 20 Oct 2004 07:49:17 -0700
| Lines: 41
| Message-ID: <F3C3AA2A-D44F-413B-9439-E4C1DACD1297@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6408
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi all,
|
| I am new to java. I need to write an applet which takes input from user
and
| updates the database. I wrote a trusted applet but i was unable to access
| network resources. Then i wrote thread inside an apllet which is working
fine.
|
| When I use JDBC-ODBC driver, its taking DSN from client machine and not
from
| server. Can i specify Server DSN?
|
| When I use Thin Drivers, I am getting ClassNotFoundException in the
| following line
|
| Driver d =
|
(Driver)Class.forName("com.microsoft.jdbc.sqlserve r.SQLServerDriver").newIns
tance();
|
| Here is my code, please let me know if anything is wrong
|
| try {
| Driver d =
|
(Driver)Class.forName("com.microsoft.jdbc.sqlserve r.SQLServerDriver").newIns
tance();
| con =
|
DriverManager.getConnection("jdbc:microsoft:sqlser ver://wks01:1433";User=tes
t;Password=pass");
| }
| catch(ClassNotFoundException e) { e.printStackTrace();}
| catch(Exception e){ e.printStackTrace();}
| finally {
| try {
| Statement stmt = con.createStatement();
| stmt.executeUpdate("INSERT INTO lms " + "VALUES ('" +
NewApplet.this.lmsVar
| + "')");
| if(con != null)
| con.close();
| }
| catch(Exception e) { }
| }
|
|
| Also, If i specify Database Server name as Server name will it resolve
from
| client
|
|
|
Hello,
Just to make sure we're on the same page, I'm assuming a "thin" JDBC driver
to mean a Type 4 driver. The Microsoft JDBC driver is one such driver.
For the ClassNotFoundException, you must ensure that the JDBC driver .jar
files are listed appropriately in your CLASSPATH environment variable or
properly specified in the "-cp" command line parameter of java.exe. The
server name used in the URL to make the connection will either specify the
database server name and instance port number OR the database server name
and SQL Server instance name:
jdbc:microsoft:sqlserver://dbserver\\instance1;User=test;Password=pass;
jdbc:microsoft:sqlserver://dbserver:1456;User=test;Password=pass;
If the SQL Server instance is a default instance, then you can simply use
port 1433 (unless you have changed this default value explicitly) as you
have indicated in your sample above.
Hope that helps!
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.