HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.newusers » create a datasource to a local sql server from Visio Professional
Topic: Re: create a datasource to a local sql server from Visio Professional
Do you really mean Visio Professional? Could it be Visual Studio
Professional? Because I don't really remember if there is some place in
Visio that you can create a "Data Source" to connect to a SQL Server
instance. (Except for the VBA stuff)
Anyway! First, ensure that your SQL Server services are running. To do this,
go to SQL Server Configuration Manager and see the services' status. Also,
to see if your SQL Server instance is a Named Instance or Default Instance,
you can check out the SQL Server services' names. If you see your SQL Server
service as "SQL Server (MSSQLSERVER)" then it means that this is a Default
Instance' s service. If it says "SQL Server (TEST1)" then it means that it's
a Named Instance and its name is TEST1.
Then let us know what Edition and Version of this intance of SQL Server is.
(For instance, SQL Server 2005 Standard Edition)
If this is not a Visio but Visual Studio, then check out this setting as
well.
Then open up Visual Studio and go to Tools\Options\Database Tools\Data
Connections and see if your SQL Server instance's name is configured
correctly.
--
Ekrem Önsoy
"JRough" <jlrough@yahoo.com> wrote in message
news:1e5ae8b1-29aa-4b9d-8de3-b8185d6fc731@s33g2000pri.googlegroups.com...
> I can't create a datasource link from Visio
> Professional tp SQL Server installed on my machine. I installed the
> Server with
> default configuration and windows authentication. I can't get all the
> way through the create DNS dialogs. It says:
> Connection failed:
> SQL STAte: '01000'
> SQL Server Error:53
> [Microsoft][odbc sql server driver ]
> [dbnetlib]connectionopen(connect()).
> connection failed:
> sqlstate:'08001'
> sql server error:17
> [microsoft]podbc sql server driver][dbnetlib]sql server does not exist
> or access denied.
>
> I think it is probably something simple I need to set up on SQL Server
> to allow a connection from Visio.
> I don't know how to change the authentication on SQL Server other than
> the basic instatllation. In the dns dialogs
> I can see all the servers except mine on my machine. I assume mine is
> a local server and that is why. I think it just needs to authenticate
> the connection on SQL Server. I thought Windows authenthication would
> be enough.
> tia,
Replies below ↓
Replies
Re: create a datasource to a local sql server from Visio Professional
SQL Server is installed by default without the ability to be seen from the
network. You need to enable the ports and protocols as well as activate the
SQL Browser service to get it to work. Use the SQL Server Surface Area
Configuration tool to enable these ports.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"JRough" <jlrough@yahoo.com> wrote in message
news:1e5ae8b1-29aa-4b9d-8de3-b8185d6fc731@s33g2000pri.googlegroups.com...
> I can't create a datasource link from Visio
> Professional tp SQL Server installed on my machine. I installed the
> Server with
> default configuration and windows authentication. I can't get all the
> way through the create DNS dialogs. It says:
> Connection failed:
> SQL STAte: '01000'
> SQL Server Error:53
> [Microsoft][odbc sql server driver ]
> [dbnetlib]connectionopen(connect()).
> connection failed:
> sqlstate:'08001'
> sql server error:17
> [microsoft]podbc sql server driver][dbnetlib]sql server does not exist
> or access denied.
>
> I think it is probably something simple I need to set up on SQL Server
> to allow a connection from Visio.
> I don't know how to change the authentication on SQL Server other than
> the basic instatllation. In the dns dialogs
> I can see all the servers except mine on my machine. I assume mine is
> a local server and that is why. I think it just needs to authenticate
> the connection on SQL Server. I thought Windows authenthication would
> be enough.
> tia,
create a datasource to a local sql server from Visio Professional
I can't create a datasource link from Visio
Professional tp SQL Server installed on my machine. I installed the
Server with
default configuration and windows authentication. I can't get all the
way through the create DNS dialogs. It says:
Connection failed:
SQL STAte: '01000'
SQL Server Error:53
[Microsoft][odbc sql server driver ]
[dbnetlib]connectionopen(connect()).
connection failed:
sqlstate:'08001'
sql server error:17
[microsoft]podbc sql server driver][dbnetlib]sql server does not exist
or access denied.
I think it is probably something simple I need to set up on SQL Server
to allow a connection from Visio.
I don't know how to change the authentication on SQL Server other than
the basic instatllation. In the dns dialogs
I can see all the servers except mine on my machine. I assume mine is
a local server and that is why. I think it just needs to authenticate
the connection on SQL Server. I thought Windows authenthication would
be enough.
tia,