Printable View
Well besides enterprise manager...
Enterprise manager open:
http://i228.photobucket.com/albums/e...priseworks.jpg
Chumpys tools cant connect:
http://i228.photobucket.com/albums/e...notworking.jpg
Chumpys site cant connect:
http://i228.photobucket.com/albums/e...notworking.jpg
I cant begin to try to get a server up if none of those connect.
Server ip : 127.0.0.1
SQL login: sa
password: Only i know :lol:
use service name not ip.
which would be
kyle\sqlexpress?
Instead of putting 127.0.0.1 in chumpys tool i put KYLE\SQLEXPRESS
and still got the same result.
=====
Also tried 192.168.1.1 and 192.168.1.106 and they failed too.
by default SQL does not listen respond to remote connectinos.... you need to open the ports in the SQL Configuration Tool that comes with sql server, not management studio.. i believe it is in the SQL surface area configuration or SQL configuration manager
I looked in Surface area and its already set up to allow local and remote connections using both TCP/IP and named pipes.
did you in the TCP/IP connection settings tell it to listen to port 1433? you have to enable that too...
those settings are in the SQL Configuration Manager under SQl Network Connection => Protocols
Your mssql is installed as a named instance, your server name is "kyle\sqlexpress", and this won't work. You need to reinstall mssql and set it to be a named instance which isn't the default for express. The mssql guide at www.mediafire.com/chumpy explains.
My mega-handly config check will warn you if this is the case. It will also attempt to enable remote connections if disabled but reinstalling is the only way to change from named to default instance. Run it on any db.
PHP Code:-- Find server name, instancename and version
Declare @insname varchar(25)
if convert(varchar(25),serverproperty('instancename')) is null
set @insname='MSSQLSERVER'
else
set @insname=convert(varchar(25),serverproperty('instancename'))
select host_name() as 'HostName',@insname as 'Instance',
serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'Level',
serverproperty('edition') as 'Edition'
if @insname<>'MSSQLSERVER'
begin
select 'THIS IS BAD! You must reinstall MSSQL' as 'MSSQL is a named instance!'
end
begin
Declare @inspath varchar(10),@reg varchar(100),@tcpremote as int
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
@value_name=@insname,
@value=@inspath OUTPUT
set @reg='Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\'
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg,
@value_name='Enabled',
@value=@tcpremote OUTPUT
select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'
if @tcpremote='0'
begin
EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg, @value_name='Enabled', @type='REG_DWORD',@value=1
select '! Please reboot !' as 'I had to enable remote connections'
end
else
begin
select 'This is good!' as 'Remote connections already enabled'
end
end
THANK YOU THANK YOU THANK YOU!!! Chumpys tools can connect!!!
But now im having some problems! Im trying to make a account with them and this is what im getting (And i know for a fact its not player already exists.. Cause it happens with anything i put in):
http://i228.photobucket.com/albums/e...ntcreation.jpg
and on his webpage (Also why does it say i have 4 accounts and 12 chars on the DB when its a fresh install and i havent even tried to connect):
http://i228.photobucket.com/albums/e...notworking.jpg
Also when i try to load the cash shop with the GM - Tool Kit i get this error:
proof GM - Tool kit is connected
http://i228.photobucket.com/albums/e...nfigloaded.jpg
Error:
http://i228.photobucket.com/albums/e...ngcashshop.jpg
Also when trying to create a account using the enterprise manager query manager i get this...
http://i228.photobucket.com/albums/e...1139/wtf-1.jpg
The NULL errors are always down to xp_md5 not working. Run the following query:
select account.dbo.fn_md5('test')
You will get a NULL when you should get a password hash. Check the extended procedures of the "master" database and check the path to the dll is correct. The problem with my gm tools is the same thing.
Not sure about CrayzArcad's tools, it's saying login failed. Have you added the cash shop db?
I added Account, cabal_managerdb, cabal_stat, and gamedb cause the guide said dont restore event.
I do not know where or how to check the extended procedures of the master database. I cant believe i was so stupid to be in a rush to try to get the md5 to work and i didnt add C:windows\system32\
Can you tell me how to check the procedures of master.
here is a off the wall sugestion.... did you enable mixed mode authentication on you sql server? buy default xpress editions are windows authentication only... just a thought as i was just having the same issue as in your screenshot of my GM Tool Kit..
Setting Mixed mode authentication solved the issue...
why my tools say Configuration Loaded, that does not mean they are connected... they only connect to the database when you are making a call to the database, ie searching, or trying to load the cash shop and so on...
Oh ok crazy so do you know how to add the mixed authentication without reinstalling?
yes open management studio... right click on the the server name, go to properties...
click security and the click the radio button for SQL Server and Windows Authentication,
then click OK and restart the SQL server Process
My tools at least sttempted to create an account and didn't fail with "access denied" (same with cash shop) so i don't think it is that. I'm guessing he didn't add the cash shop db and when trying to select a non-existent database it returns a stupid error, most sql errors are.Quote:
Originally Posted by CrazyArcad
The "duplicate row exists" that you get in my tools when xp_md5 is broken is a perfect example. Ok, i have "translated" the error but the original has exactly the same wording and no duplicates exist! It took me ages to work out what the error actually meant.
Check the cash shop readme as there is another db to create for the cash shop. There is no file to restore it's just a query that creates an empty db.Quote:
Originally Posted by Thesnowman
Open the "master" database and underneath it find the "extended procedures" folder. Somewhere in there is an entry for "xp_md5", check it's properties to see whee it is looking for the dll. If it just has "xp_md5.dll" it expects c:\windows\system32.
@Crazy
When i click security this is what i see:
http://i228.photobucket.com/albums/e...serverpros.jpg
@Chumpy
Ok so i opened the folder where i extracted all the DBs and MD5.dll and there is no cabal shop readme. Just a cabalcash.file when i open with notepad there is nothing except encrypted words. And a Cabalcash_data sql file. No cabal shop related files in there....
Also when i open master database all i see is:
>Tables
>Views
>Synonyms
>Programmability
>Security