I rented a second server yesterday as the other one I have is almost full all day long. I installed everything on both computers, installed SQL 2005 on both and created server in one like I always do. This server works like a charm. Now, when I need to create the other server I create the ODBC's and make them point to the other computer, press TEST and its success
The config shows:Microsoft SQL Server ODBC Driver Version 03.86.1830
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
I can see the database from Server 2 if I open SQL Server Management Studio, so the connections are open. I only allowed tcp/ip, should I allow pipes 2?.Microsoft SQL Server ODBC Driver Version 03.86.1830
Data Source Name: MuOnline
Data Source Description:
Server: (ip) ^^
Database: MuOnline
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
When I run link 1 I get:
but my sql user isnt Admin, its 'sa'!SQLState:'28000' Error de SQL Server:'18456' [Microsoft][ODBC SQL Server Driver][SQL Server]Error de Inicio de Sesion del usuario 'Admin' (Means error loging to the session Admin, the typic not trusted user error)
When I go to sql error logs I get:
I googled and found that State 5 is Invalid userid and I know that "admin" isnt my user. Sa is my user but I cant find a way to change that admin to SA => I cant have a subserver.2007-07-18 19:38:37.84 Login failed for user 'admin'. [CLIENT: (ip)^^]
2007-07-18 19:38:38.65 Error: 18456, Severity: 14, state: 5.
The config is:
All ips in mu config point to Server 1
All ODBC Point to server 1
Any help? I feel pretty depressed. I've being hosting for over 2 years and made several subs but this bitch refuses to work!
After the sql error I mentioned I get:
EventDBset ODBC Connect Failed
GSDBeset ODBC Connect Failed


![[Help] Subserver issues (2 PC - 1 DB)](http://ragezone.com/hyper728.png)

