Problems with SQL installation

10/21/2013 03:25 Prideness#1
Hello,

Today I'm trying to make an offline test server, although it aint going as planned. After having the database and game actually fine, I couldn't get past server selection window, I got DCed. I tried to fix it with a guide here on EPvP, which I actually *** up SQL with.

I reinstalled SQL, or at least tried to and the first time, it went succesful, but after opening the SSMS I couldn't connect due to a named pipes error. Windows forum said I should reinstall and so I did. The SP1 for SQL 2012 brought an error I can't remember, so I reinstalled again. Now I checked off the box to install SP1 update and later on at Installation Progress I'm having an error "Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes." Windows forum told me to change the first box of Server Configuration to "NT AUTHORITY/LocalService" (It's on NT AUTHORITY/MSSQL on default I believe). But I can't change it, and when I manually type it, it gives an error that the filled in account information is not verified or true, I tried to do it with or without password but no luck.


So the current error I'm dealing with is "Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes." I again uninstalled SQL 2012, and deleted anything that said SQL, also deleted files from SQL in regedit, and my PC has nothing with SQL in/on it right now(also scanned my PC on any left files). But as I'm already spending almost a full day, including yesterday evening, I'm getting sick of it and I'd appreciate it if it would success for once :bandit:.


Any help is appreciated :handsdown:

PS: I'm using the SQL 2012 Express With Tools installer
10/21/2013 13:46 Bothar#2
is your linked server set up ok? and maybe try 2008 works fine for me
10/21/2013 16:35 Prideness#3
Don't know about linked servers but I installed it like I always do, and the first time SQL succeeded perfectly and it worked like a charm. 2008 actually gave the same errors and 2012 is required for the server files I am planning to use.
10/21/2013 19:18 Shànks♠#4
Best guide to install your SQL correctly
Credits to thetruestarr1337
10/22/2013 00:10 Crazehツ#5
Code:
/* Add linked servers */

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
	EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
	EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';
Change credentials and execute It.
10/22/2013 06:48 Bothar#6
yup this one is pretty needed lol