Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
omid
Starting Member
1 Post |
 Posted - 2006-02-03 : 02:17:48
|
| Dear Sirs,I am working on my first sql server web application. I have read many documents and I have gone to many forums, but i have'nt found any answer. Can you help me please.Here is my problem:I can't connect to my database. I use windows authentication and i log in as administrator. I have installed personal edition of sql server and IIS is installed in my computer. I use this scripts:<% dim objConset objCon = server.CreateObject("ADODB.Connection")objCon.ConnectionString="DSN=dbna.dsn;uid=sa;pwd=;database=na2"objCon.open%>Where dbna.dsn have been defined in "Data Sources (ODBC)" part of control panel. When I open the webpage i receive this error:Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ALADDIN\IUSR_ALADDIN'./dbconnect.asp, line 5My computer name is ALADDIN and my username is Omid.Best regards,Omid. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-03 : 12:38:55
|
Welcome to SQLTeamsee www.connectionstrings.com  |
 |
|
|
|
|
|
I can't connect to my database