Connection Problem - Newbie Ques

[Majordog]

Hi All - I set my connection string:

DatabaseKey = "Data Source=ERMDSQLSERVER;" _

& "Integrated Security=SSPI;" _

& "Trusted_Connection=yes;" _

& "initial catalog=ERMD;"

 

When I try to open it with the following function:

Public Function get_TechnicianList(ByVal command As String) As SqlDataReader
           Dim sqldrTechnicianList As SqlDataReader
           Dim sqlConn As SqlConnection = New SqlConnection(DatabaseKey)
           Dim sqlCmd As SqlCommand = New SqlCommand(command, sqlConn)

           sqlCmd.Connection.Open()
           sqldrTechnicianList = sqlCmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
           Return sqldrTechnicianList
       End Function

I get error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I have been looking ao-line for fixes and have confirmed/verifid that all my settings are set to windows NT authentication

Can anybody help me???

Edited April 1, 2003 by Robby

[Robby]

try this...

 

DatabaseKey = "Server=ERMDSQLSERVER;" _

& "Trusted_Connection=yes;" _

& "database=ERMD;"

[Majordog]

The change still generates the same error.

[Robby]

if ERMDSQLSERVER is a local server then try this instead 127.0.0.1

[Majordog]

Hi Robby,

The server is not local, but remote. It also has two named instances running on it.

[Robby]

Just grab a Connection from the data - toolbar, it allows you to test the connection.

 

or create a UDL file on your Desktop, right-click on your desktop > New > Text File > then rename the extension to .UDL