Nothing can access my SQL?!?

[Thesnowman]

Well besides enterprise manager...

Enterprise manager open:



Chumpys tools cant connect:



Chumpys site cant connect:



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

[MentaL]

[cypher]

use service name not ip.

[Thesnowman]

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.

[CrazyArcad]

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

[Thesnowman]

I looked in Surface area and its already set up to allow local and remote connections using both TCP/IP and named pipes.

[CrazyArcad]

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

[chumpywumpy]

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.

-- 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 

[Thesnowman]

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):



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):



Also when i try to load the cash shop with the GM - Tool Kit i get this error:

proof GM - Tool kit is connected



Error:



Also when trying to create a account using the enterprise manager query manager i get this...

[chumpywumpy]

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?

[Thesnowman]

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.

[CrazyArcad]

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...

[Thesnowman]

Oh ok crazy so do you know how to add the mixed authentication without reinstalling?

[CrazyArcad]

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

[chumpywumpy]

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...

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.

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.

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.

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.

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.

[Thesnowman]

@Crazy

When i click security this is what i see:



@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

[CrazyArcad]

@Snowman here are the cash shop databases, just attach them to you sql server, add you user to their security and you should be good to go,

this DB is from my server so it is fullly set up with items and prices etc

[Thesnowman]

in the rar you only gave me an mdf and a log. i cant restore it.

[CrazyArcad]

you dont need to restore it, you just need to ATTACH it

those are copies of the database, not backups

[Thesnowman]

so what would the database name be and how would i go about attaching it.

[CrazyArcad]

open management studio the right click on the Database folder click Attach, browse to the location where you have the database files i just send you. select the CashShop.MDF file and click ok

thats it..

[Thesnowman]

what do i name the database?

[CrazyArcad]

CashShop is what it should be named.

[AdriaN401MasteR]

Fix has added some account like test account.... also..... md5 extended procedure is not installed corectly that why you can create new account... with gm tools or with query... and that error from toolkit.. I dont use those tools just use cabal manager(look at resources) and cumpy gm toolz...

[Thesnowman]

CashShop is what it should be named.

its not working. Everytime i try to attach it i get this

[CrazyArcad]

Here is a cashshop database backup file... just restore it, but first delete any batabase named cashshop that you may have from the Sql Management Studio