Newbie Spellweaver
- Joined
- Mar 31, 2014
- Messages
- 20
- Reaction score
- 0
SQL SERVER 2008 R2 RTM ERROR
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Data Source='(local)'
Data Source='DESKTOP-1TDUSCD\SQLEXPRESS'
That config was for MSSQL 2000 so '(local)' won't work in MSSQL 2008 R2 RTM.
To fix it edit the server Config.ini and change this
Code:Data Source='(local)'
To the name of your computer or machine \ The name of your sql instance.
Code:Data Source='DESKTOP-1TDUSCD\SQLEXPRESS'
To change security authentication mode
- In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
- On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
- In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
- In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.
To enable the sa login
- In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
- On the General page, you might have to create and confirm a password for the login.
- On the Status page, in the Login section, click Enabled, and then click OK.
Either you put the wrong password or you didn't set the right authentication mode. Make sure that the authentication mode is set to "SQL Server and Windows Authentication mode" and also choose a password for the "sa" login.
FromYou must be registered to see links.
[ERROR] Source: ??
[ERROR] Detail: ??
What did the GameServer print?
Code:[ERROR] Source: ?? [ERROR] Detail: ??