<div>
A correct UserID and password?<br />
<br />
<a href="http://www.connectionstrings.com/" rel="ugc">http://www.connectionstrings.com/</a>&nbsp;has a detailed listing of many connection string templates. <br />
<br />
Hope this helps.<br />
-Jim
</div>


A correct UserID and password?

http://www.connectionstrings.com/ [http://www.connectionstrings.com/] has a detailed listing of many connection string templates.

Hope this helps.
-Jim

<div>
yes i have the correct user name and password 
</div>


yes i have the correct user name and password

<div>
<div class="content wysiwyg-content">
I am using the following DSNLESS connection to access info from sql server 2003 and I am getting the following error<br />
<br />
----Connection----------<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set cn = Server.CreateObject(&quot;ADODB<wbr />.Connectio<wbr />n&quot;)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cn.connectionstring = &quot;Provider=SQLOLEDB.1;Persi<wbr />st Security Info=False;User ID=iwilliams;Password=4161<wbr />023;Initia<wbr />l Catalog=CustomerMaster;Dat<wbr />a Source=CITSCUSTMAST&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cn.OPEN<br />
<br />
<br />
----error------<br />
Microsoft OLE DB Provider for SQL Server (0x80004005)<br />
[DBNMPNTW]Access denied.<br />
<br />
any idea how to correct this problem<br />
<br />
thank you
</div>
</div>


I am using the following DSNLESS connection to access info from sql server 2003 and I am getting the following error

----Connection----------
	set cn = Server.CreateObject("ADODB.Connection")
	cn.connectionstring = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=iwilliams;Password=4161023;Initial Catalog=CustomerMaster;Data Source=CITSCUSTMAST"
	cn.OPEN


----error------
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNMPNTW]Access denied.

any idea how to correct this problem

thank you

Access Denied Error

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.