No process is on the other end of the pipe?

[Prkchop]

im trying to set up a website for my server and i cant connect


@mssql_connect("kurt-PC\Jacob Stanley", "Account MSSQL", "PASSWORD")

i use windows auth to log into my database what do i put for my password?

also if i try to log in using server auth i get this error



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

Cannot connect to kurt-PC.

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

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

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



i have no idea what to do and when i open my webpage it says server is down and theyre up


anyone have any ideas?

[MentaL]

[Treachery]

"kurt-PC\Jacob Stanley" is a named pipe. kurt-PC is the name of the computer, and where Jacob Stanley is (I'm assuming that's your username?) is where the instance of SQL Server is supposed to be. Most likely, it's "kurt-PC\SQLEXPRESS" unless you changed it during installation.

Just look to see what SQL Server Management Studio connects to.

[Prkchop]

i did but what do i put as my password if i use windows auth

[Treachery]

If you would use Windows Authentication, you just use:

mssql_connect("kurt-PC\SQLEXPRESS"); 

Or at least, when I did that, it would work for Windows Auth. If that doesn't work, you should have installed mixed authentication so you would have a "sa" account.

[Symbolic.]

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Configuration Manager.
Then SQL will probably be disabled not the Browser one the one above it and it would probably be disabled. Then just right click it and hit start