[Help] SQL ODBC error

[Anthon Hedlund]

Hello, when I am at this stage:

Data Sources (ODBC)
1. Open Start -> Run
2. Type odbcad32.exe and click OK
3. Select tab System DSN and click on Add…
4. Select SQL Server Native Client 10.0 and click Finish
5. A new window will open. In the name box type WarZ. You can leave the description empty.
In the Server box type WarZ and click Next to proceed.
6. Set the option to With SQL Server authentication using a login ID and password entered by the user.
7. Enter Login ID: wz_api_user Password: 123456
8. Click Next to proceed
9. Select Change the default database to: and select WarZ as the value
10. Click Next to proceed
11. Click Finish
12. Click Test Data Source to see if it works.



I am getting SQLState: 08001
SQL Server Error: 126

Do someone know why?

[MentaL]

[DNC]

This is not Microsoft Support, use google.
It promptly gave several solutions to your issue.
This is Not a WarZ / Infestation issue.

Named pipes and TCIP protocols for SQL server 2005 are disabled by default. Have you enabled them under "SQL server configuration manager"? You can find the protocols in the SQL Server Network configuration and under SQL Native client xx configuration.
The connection on the server itself works thanks to the "Shared memory" protocol.

If you go to the Dragona Section and watch my full video on setting up a Dragona Server, you'll find at the very beginning of the video.
The first 5 minutes or so, that the answer to your problem is visible and explained in the video.
Here is the video link (This is not safe for work, as I do talk like I always do. Be sure you either have your headphones on or are not somewhere it can cause a conflict of family or job).

http://www.youtube.com/watch?v=CSuM_EzFcac

I highly recommend when it is not Game related issue that you attempt to search offsite for the Non-Game related issue.