December 2, 2009 at 4:14 am
Hi folks,
I am trying now for hours, but with no satisfying result.
I have a MS SQL 05 DB running on a remote server with the IP Address A.B.C.D and i have also set up a test database with a table.
Now I want Excel to connect to this tatabase, but it always gives me following errormsg: [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or Access Denied
So I don't even know if I can connect to the DB or if just the Login Information is wrong... Does maybe some1 has experience with connecting to a remote SQL Server?
I use A.B.C.D\SQLEXPRESS for the Server Name and the SQL Login I added to the Database.
Cheers,
prozero
December 2, 2009 at 5:25 am
pro_zero (12/2/2009)
Now I want Excel to connect to this tatabase, but it always gives me following errormsg: [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or Access Denied
How are connecting from Excel to SQL Server? Explain the steps.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 2, 2009 at 6:20 am
I want to import data from a SQL server (DATA -> From other Sources -> From SQL Server).
Then I enter the servername myip\SQLEXPRESS
Then I switch to "Use the following Name and Password"
Then I enter my user information and I click on next - and then the error comes up as in my first post.
December 2, 2009 at 7:55 am
Is your SQL Instance named as Express?
Is SQL in mixed authentiication mode?
Are the named pipes enabled?
Check these out.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 2, 2009 at 8:28 am
Is your SQL Instance named as Express?
Yes, if I connect to it on the Server I use COMPUTERNAME/SQLEXPRESS
Is SQL in mixed authentiication mode?
Yup.
Are the named pipes enabled?
Dunno. Where can I look that up? Anyways, I think the Server has some Firewall Settings that prevent me from connectiong...
December 2, 2009 at 8:30 am
pro_zero (12/2/2009)
Are the named pipes enabled?
Dunno. Where can I look that up? Anyways, I think the Server has some Firewall Settings that prevent me from connectiong...
Look in SQL Server Configuration Manager and under network configurations
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply