Sql Server 2005 Dev Edition Not connecting on Windows 2003 Server from Win 7

sql-server-2005

Management Studio of Sql Server Dev Edition 2005 installed on Win 7 is not able to connect on Windows 2003 Server where standard edition of sql server 2005 is installed.

The connection is working when I use the Sa password but when I use windows authentication then it is showing err msg that "user is not associated with a trusted sql server connection"..

I'm using a local admin password on win 7 and in passwords server password is saved (i.e. the domain password), I'm even able to get exchange mails so domain pass is working fine from other places but sql server is not able to connect..

Pls help

Best Answer

Passwords are not used while using windows authentication :) Your client computer credentials need to be trusted by SQL server - this is easiest to achieve for domain (Active Directory) accounts.

You need 1) login into your dev computer as domain user 2) add same domain user (or containig group) to sql server permitted logins for your database.

Related Solutions

Sql-server – How to determine total number of open/active connections in ms sql server 2005

This shows the number of connections per each DB:

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame

And this gives the total:

SELECT 
    COUNT(dbid) as TotalConnections
FROM
    sys.sysprocesses
WHERE 
    dbid > 0

If you need more detail, run:

sp_who2 'Active'

Note: The SQL Server account used needs the 'sysadmin' role (otherwise it will just show a single row and a count of 1 as the result)

Sql – Connecting to SQL server from Virtual PC

Make sure that the VPC is not using NAT for its network connection.

Also check your configuration to be sure remote connections are allowed. Remote connection is turned off by default.

Best Answer

Related Solutions

Sql-server – How to determine total number of open/active connections in ms sql server 2005

Sql – Connecting to SQL server from Virtual PC

Related Topic