Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
free
Starting Member
3 Posts |
 Posted - 2007-10-31 : 04:13:00
|
| Hi folks,I have installed SQL Server 2005 on my Domain Controller successfullyand installed the SQL Server tools from the DVD including workstation components on my XP client computer (which is actually hosting the Domain controller as virtual VMWare machine).The authentication is set to mixed mode and I have created a login with all possible rights on SQL Server, but which is at the same time my Domain Admin (So the user is setup in SQL Server in the format Domain\user)Now when I open any client program (SQL Srvr2005 Management console, or Toad for SQLSrvr) and try to connect, the client does find the server correctly, but I cannot login.The error status is actually 1, which means "unexpected internal error" as far as I have read.I have turned off Windows firwalls by default and also turned off my custom firewall to see if it makes a difference, but it doesn't.My activated connection protocol on both the server and the client is TCP/IP and I have then changed the port on both the server and the client to a common 4665, which I then granted full passage through my firewall.Now the error has changed and says "the target machine has actively refused the connection", with status code 0... ???So that's my current situation... Please, can anyone help me? What am I doing wrong?Any tips would be appreciated,-Patrick- |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-31 : 22:34:30
|
| Which authentication did you use to connect to sql server? Is it named instance? Did you specify correct instance name? Tried connect with ip address and port number? |
 |
|
|
free
Starting Member
3 Posts |
Posted - 2007-11-01 : 02:14:17
|
quote:
Originally posted by rmiao
Which authentication did you use to connect to sql server? Is it named instance? Did you specify correct instance name? Tried connect with ip address and port number?
I just found out: Since the Sql login I created was a domain user, I needed to be logged in to the client machine as that domain user and then use windows authentication from the client application! Then I could login.I thought since I used Mixed Authentication mode at the installation of sql server, I would be able to just use SQL authentication, entering the login name with domain in front, from any machine... But apparently not.I did specifiy the correct instance name btw, as I only have that one default instance, and the client application was able to find that server easily when searched for it.I think I know more now. Thanks for the reply!-free- |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 22:21:23
|
| Sql authentication will work if you connect with standard sql login like sa. |
|
|
|
|
|
|
|
|
SQL client connection in AD Domain