SQL express studio PROBLEM PL0X HELP

Guys iam making my own gunz and when i log in it gives me this


TITLE: Connect to Server
------------------------------

Cannot connect to FUNNYMASTER\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: Source: ID: ( ) - Events And Errors Message Center: Message Details

------------------------------
BUTTONS:

OK
------------------------------


HELP -LX

Please search the forum before creating more threads of similar problems. I have search the forum and found two pretty good guides. There is a tutorial sub-forum.

Links

Code:

---

http://forum.ragezone.com/f497/remot...on-sql-707602/
http://forum.ragezone.com/f497/mssql...tering-651315/

---

Remote connection will fix it error. But, if you using windows 7, you must run as administrator with SQL Management thought you are config Surface Area.
Remember : Always run as administrator !!

Did you edit dbo.serverstatus and dbo.locatorstatus
Did you added the odbcad in USER DNS?
Did you check already for some typemistakes in server.ini?

Quote:

---

Originally Posted by ForceGFX

Did you edit dbo.serverstatus and dbo.locatorstatus
Did you added the odbcad in USER DNS?
Did you check already for some typemistakes in server.ini?

---

You do know you're misguiding him, don't you? He's connecting to SQL through the Management Studio, no GunZ related.

Try messing around with the SQL Browser configurations(sql config manager or whatever it's name is.)
Posted via Mobile Device

You need to install two things.

32-bit: SQLEXPR32.exe and SQLServer20XX_SSMSEE.msi (where XX is the year; ex. 05/08/etc.)

64-bit: SQLEXPR_x64_ENU.exe and SQLServer20xx_SSMSEE_64x.msi (where XX is the year; ex. 05/08/etc.)

I has met it before.
Two ways to fix ( u must do two ways ) :
1. Start -> All Programs -> MS SQL 2005/2008 Express -> Configuration Tools ->SQL Surface Area Configuration -> Choose Surface Area Configuration for Service and Connections -> Choose Database Engine -> Remote connections ->
Click on Local and remote connections -> Choose using both TCP/IP and Name pipes-> Then click Service -> click on Stop and Start again.
2. Right click on SQL Management Studio Express-> Properties -> Choose what anything to make it always run as administrator or you right click and choose run as administrator
I'm sure this only two ways to fix it.
The first way from Microsoft Technical Support.
The second way from me when i try to make SQL Server and first way i can't fix it.
Good luck to you !