Login failed for user 'sa'
- From: "jyetying" <yam_jyet_ying@xxxxxxxxxxx>
- Date: 16 Dec 2006 04:31:11 -0800
Hi
When I try to run my VB form, I get this error msg: Login failed for
user 'sa'. I had click on the Properties of the server, then security,
In the frame of authentication, I click on SQL Server and Windows,
Audit Level: None. Is this setting correct? I have no idea why I am
getting this error. When I debug, it shows on line "adoConn.Open".
Can you all help me? Your help is appreciate.
Below is my VB code to connect database:
Public Function functConnectDatabase()
Dim strConn As String
Set adoConn = New ADODB.Connection
adoConn.ConnectionString = strConn
strConn = "Provider=sqloledb;Network Library=DBMSSOCN;Data
Source=Yam_J,1433;"
strConn = strConn & "Initial Catalog="
strConn = strConn & "E_PASSPORT;"
strConn = strConn & "User ID=sa; Password="
adoConn.ConnectionString = strConn
adoConn.Open
End Function
.
- Prev by Date: Database Mail in SQL Server Express 2005
- Next by Date: Re: SQL 2005 execute permissions
- Previous by thread: Database Mail in SQL Server Express 2005
- Next by thread: Re: system account for sql2005
- Index(es):
Relevant Pages
|
|
