Can not connect to MS SQL server

Hi I have problems with connecting to MS SQL server.

SQL server is configured to log in with Windows Authentication mode.

The only thing I need is to configure the web.config.

My configuration in web.config-file is as follow:

<appSettings>

<addkey="forumDSN"value="server=localhost;uid=;pwd=;database=forum"/>

</appSettings>

I get the following message afte running my ASP page:

Exception Details:System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

HELP please.

Is the SQL Server on the same machine as the Web server? In the real Web.Config, to you provide an actual uid and password?|||

Hey hi,

1st u check out wheter the sql server whichs running has got any name...coz, some times the local host is not taken as the default instead, its named with some name.

to check that, just open the sql server service manager, there u can C Server :"........"

that name should be used.

also for further details go through the following link

http://www.functionx.com/sqlserver/Lesson01.htm

also the this one for the security issues

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp

hope this helps

all the best

|||

yes, It is in the same machine running WindowsXP

thanks

sql