What I'm really trying to do is get a connection string to a database from an ASP page using ADO.
But first I'm trying to get the SQL server configured properly. Under SQL server groups in Enterprise Manager I have a SQL server called "mark(windows NT)". First Question-I want to change mark(windows NT) to mark(SQL authentication). If I expand mark it says connection failed. If I go into edit registration property dialog box it asks for my Login name and password. when I click ok it says connection failed for username. I use mark as username.
But first I'm trying to get the SQL server configured properly. Under SQL server groups in Enterprise Manager I have a SQL server called "mark(windows NT)". First Question-I want to change mark(windows NT) to mark(SQL authentication). If I expand mark it says connection failed. If I go into edit registration property dialog box it asks for my Login name and password. when I click ok it says connection failed for username. I use mark as username.