What are the challenges you face when working across database platforms? Take the survey

Connections From VS 2005 Server Explorer

MikeONeillMikeONeill Posts: 131
edited July 27, 2007 10:47AM in SQL Prompt Previous Versions

I have created a new db project and added an sp to it with no problems

As you create the new project you are asked to define a specific connection , with appropriate credentials, in this case SQL Authentication

When I connect to the same database and apply the same credentials to show the connection in the server exporer , all seems well. I can see everyhtnig , open tables etc

Now I open the sp I have just created in the db project and attempt to add more code and SQL Prompt 3.5 doesn't pick up any tables etc

I have created a connection in the Connections tab of the SQL Prompt options with the same credentials

I get an error that loks like its trying to connect with windows authenticationa and doesn't recogniose my Windoes logon , as it wouldn't

Any ideas


Sign In or Register to comment.