Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Trouble connecting SQL Server 2005 to VWD 2008

Author  Topic 

KarinElvira
Starting Member

47 Posts

Posted - 2010-08-10 : 06:43:11
I'm trying to connect MS SQL Server 2005 to Visual Web Developer 2008 but can't seem to find how to type the server name correctly. I've looked through a bunch of tutorials but they all take for granted that the "connection-log on" is without complications... Thankful for any help!
[computername]\SQLEXPRESS is apparently wrong.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-08-10 : 07:30:12
Is it all on the same computer? [computername]\SQLEXPRESS usually works but there can be issues with the windows firewall, the service might have stopped or the account you are trying to access the server with might not have proper access.

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page

KarinElvira
Starting Member

47 Posts

Posted - 2010-08-10 : 08:18:38
Yes, It's all on the same computer. I'll check the firewall, I hadn't thought of that. I've made sure the server is started, so that shouldn't be the problem. How can I check if the account has proper access?
Go to Top of Page

KarinElvira
Starting Member

47 Posts

Posted - 2010-08-11 : 05:44:16
Well, so far I've reinstalled the sql server, then followed the steps here:
http://www.aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx
and here:
http://www.sqlservercurry.com/2008/04/resolving-create-database-permission.html
to solve additional problems.

When I try to Add connection the Test connection succeds, but the actual connections gives the error message:
"Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The file can't be found."

What does it mean?
Go to Top of Page

KarinElvira
Starting Member

47 Posts

Posted - 2010-08-11 : 09:58:35
Answering my own post again: In another forum I was told to install Microsoft SQL Server System CLR Types, Microsoft SQL Server 2008 Management Objects and Microsoft SQL Server 2008 Native Client. I did so, restarted the computer but still get the exact same error message.

So the problem has changed but I the subject is still the same. Any ideas on a solution?
Go to Top of Page
   

- Advertisement -