Hi,

I've been reading Tom Fords article on Access and SQL Server Integration, http://www.mssqltips.com/tip.asp?tip=1470.

I'm new to database management and I've gottn hung up at the login step.

 As the article suggests I'm trying to login with SQL Server authentication.

I get this error message:

"Connection failed:

SQLState: '01000'

SQL Server Error: 2 

[Microsoft][ODBC SQL Server Driver][Shared Memory][ConnectionOpen(Connect()). 

SQLState: '08001'

SQL Server Error: 17

 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied."

I'm using the freeware version of Microsoft SQL Server 5 and XP pro.

Searching the web I found that somoeone had tried unchecking  "Dynamically determine port". It didn't work for this person, but they sounded like they expected it to work. Following this option requires you supply a port number. If this is an option worth exploring, how could I find which port number to use.

 Any help would be appreciated. 

Thanks,

Stephen 

A little more info - the freeware version is also known as SQLExpress.

Some more searching suggested making sure the SQL agent service was running.

My SQL Server Configuration Manager does not show SQL Server Agent as being a service that is available.

Is that the crux of the problem, not having the SQL Server Agent? 

Hi Pls Check Your SQL Server Name,DSN Name, UserId,DataBaseName And Password When Accessing the DataBase, If All these correct the DB Will Open Correctly

Pls Take care With checking these, If I Give Wrong, Pls give Correct Answer to me

Thank You