Friday, March 23, 2012

Problems connecting with VS.NET Server Explorer

I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
When I try to connect to my SQL Server from the VS.NET Server Explorer I can
expand the server and look at the SQL Server instance on my computer but when
I try to expand the instance, I get a login dialog entitled "SQL Server
Login" which asks for Login and Password. When I put in what I think the
Login and Password should be, it tells me, "The specified procedure could not
be found". If I check the option that says, "Use Windows NT Integrated
Security" it tells me "The specified procedure could not be found". I need
some assistance from some gurus. What's going on here?!!
I cannot help you but have a similar problem. I can add servers, but never
connect and see details. Worse yet, I cannot create a connection. I go
through the dialog and click test connection and get connection "test
connection succeeded" message. When I try to finish the task I get a message
twice saying "Unable to connect to database. The connection failed. Check
your username and password, and try again." Using either Enterprise Manager
or Query Analyzer, I can connect to the server and databases and see whatever
I need to.
I have Visual Studio 2003, I am trying to connect to both a MSDE SP3 (same
machine) and SQL Enterprise SP3 (different machine).
I am not sure when exactly this occurred as in the past I had created some
connections. I noticed it within the last couple weeks as I have gotten back
into .Net for my current project. I cannot use the old connections and once
deleted cannot recreate them as above.
"DBase_Tron" wrote:

> I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
> When I try to connect to my SQL Server from the VS.NET Server Explorer I can
> expand the server and look at the SQL Server instance on my computer but when
> I try to expand the instance, I get a login dialog entitled "SQL Server
> Login" which asks for Login and Password. When I put in what I think the
> Login and Password should be, it tells me, "The specified procedure could not
> be found". If I check the option that says, "Use Windows NT Integrated
> Security" it tells me "The specified procedure could not be found". I need
> some assistance from some gurus. What's going on here?!!
|||

Quote:

Originally posted by DBase_Tron
I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
When I try to connect to my SQL Server from the VS.NET Server Explorer I can
expand the server and look at the SQL Server instance on my computer but when
I try to expand the instance, I get a login dialog entitled "SQL Server
Login" which asks for Login and Password. When I put in what I think the
Login and Password should be, it tells me, "The specified procedure could not
be found". If I check the option that says, "Use Windows NT Integrated
Security" it tells me "The specified procedure could not be found". I need
some assistance from some gurus. What's going on here?!!

|||I have been searching news groups and Microsoft support sites for two days now and finally found a solution to our problem. You should download MDAC 2.8 and install. Apparently a new procedure has been included in this release. Good Luck.|||I had the same problem and what did to solve it was removing the Alias in
the SQL Server Client Network Utility, done.
Hope it helps
Javier.
"Matt Wyncoop" <Matt Wyncoop@.discussions.microsoft.com> wrote in message
news:E55058DA-AA95-48BA-930C-0726BDCAEA28@.microsoft.com...[vbcol=seagreen]
>I cannot help you but have a similar problem. I can add servers, but never
> connect and see details. Worse yet, I cannot create a connection. I go
> through the dialog and click test connection and get connection "test
> connection succeeded" message. When I try to finish the task I get a
> message
> twice saying "Unable to connect to database. The connection failed. Check
> your username and password, and try again." Using either Enterprise
> Manager
> or Query Analyzer, I can connect to the server and databases and see
> whatever
> I need to.
> I have Visual Studio 2003, I am trying to connect to both a MSDE SP3 (same
> machine) and SQL Enterprise SP3 (different machine).
> I am not sure when exactly this occurred as in the past I had created some
> connections. I noticed it within the last couple weeks as I have gotten
> back
> into .Net for my current project. I cannot use the old connections and
> once
> deleted cannot recreate them as above.
>
> "DBase_Tron" wrote:
|||I looked there and I have no aliases.
"Javier Troconis" wrote:

> I had the same problem and what did to solve it was removing the Alias in
> the SQL Server Client Network Utility, done.
> Hope it helps
> Javier.
> "Matt Wyncoop" <Matt Wyncoop@.discussions.microsoft.com> wrote in message
> news:E55058DA-AA95-48BA-930C-0726BDCAEA28@.microsoft.com...
>
>

No comments:

Post a Comment