You most likely have missed something in the configuration of your SQL Server, you might want to double check on that
|
|
|
|
|
|
Yes change Active Yes and 127.0.0.1Quote:
DB UserLog Connect Error: 127.0.0.1 - DB: PS_UserData.dbo.User_Master , User: Shaiya, Password: Shaiya123
Please Check your Database Connection: SQL-Server Configuration , Protocols for SQL Express > TCP/IP > Properties > IP-Address
did you changed the IP-Addresses to: Active: Yes and : 127.0.0.1 ?
Ok. i m need now Instal SQL 2008 Express ?Quote:
And you can connect over Managment Studio trough 127.0.0.1 with Shaiya as User and your Password which used for Shaiya-Server ?
If yes: i think it's just up on SQL 2008 - try to use 2005 Express or 2008 Full Trial Version 180 Day.
If not: Check your Named Pipe. it Should be: \\.\pipe\sql\query > Rightclick > Named Pipes > Properties.
i tried it with SQL 2008 Express and something went wrong. i guess sqlcmd.exe works not correctly (full) for Express Versions. i can't try it now because i'm at work.
but i try it later with differnt SQL Express Version and if it works correctly i change it in my Tutorial.
You're not the only one who have Problems with SQL 2008 Express.