lyanez30
asked on
Problem connecting to MS SQL server Msg 17, Level 16, State 1
Hi,
We had some trouble with oir server, windows 2003 standard server, it locked up, we rebooted it and everything went up normal, including the MS SQL 2000 sp4 database.
We have a webpage that connects to the database and works fine, but when we try to connect trough query analizer remotely to the server we get this error:
Msg 17, Level 16, State 1
The sql server does not exist or it has denied access
We where able to access the server before this reeboot.
Can anyone point me in the right direction?
We had some trouble with oir server, windows 2003 standard server, it locked up, we rebooted it and everything went up normal, including the MS SQL 2000 sp4 database.
We have a webpage that connects to the database and works fine, but when we try to connect trough query analizer remotely to the server we get this error:
Msg 17, Level 16, State 1
The sql server does not exist or it has denied access
We where able to access the server before this reeboot.
Can anyone point me in the right direction?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
on the sql services manager it is to on automaticaly start with the OS
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I´m connecting via the internet through IP
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I restarted the service several times with no luck.
I can ping the server just fine, good times too, the user has all permissions the MSSQL server is running on port 1433.
I have tried looking for the protocols you mention but cant find them.
I've run into a network configuration button on the general tab, it has TCP/IP and name activated
On the windows services panel i deactivated the ICS firewall service, so no windows firewall is running, i have no other firewall installed.
I installed Toad and it cannot connect either.
I can ping the server just fine, good times too, the user has all permissions the MSSQL server is running on port 1433.
I have tried looking for the protocols you mention but cant find them.
I've run into a network configuration button on the general tab, it has TCP/IP and name activated
On the windows services panel i deactivated the ICS firewall service, so no windows firewall is running, i have no other firewall installed.
I installed Toad and it cannot connect either.
ASKER
Also on Event Viewer I have a SuperSocket: (SpnRegister) : Error 1355 warning.
I have no Active Directory on this server, so I dont know if it is related
I have no Active Directory on this server, so I dont know if it is related
ASKER
This is recent, if I authenticate the users though windows, they can connect.
I did this using windows explorer with the url \\serverip and giving nt user credentials
Unfortunately not all computers accepted this
I did this using windows explorer with the url \\serverip and giving nt user credentials
Unfortunately not all computers accepted this
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Alas, sorry for the fuss, turns out my ISP blocked ports 1433 and 1434, I have talked to them and they ageed to unblock it for my server.
Thank you all for your support
Thank you all for your support
ASKER
Thank you for your support
ASKER