I need to load data from a table in sqlserver to a table
in an instance of the same server. The query need to be
run in the SQL server itself not in the instance. So...
insert into [servername\instancename].[dbname].
[dbo].table1 (
col1,
col2)
select
t2.col1,
t2.col2
from table2 as t2
I keep getting this message:
Server 'CNS-SFO-A46\QA' is not configured for DATA ACCESS.
Thanks in advance for you help.This is a multi-part message in MIME format.
--=_NextPart_000_038B_01C3D5F9.27781520
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
In Enterprise Mgr, right click on the linked server - CNS-SFO-A46\QA. Bring
up the properties, click on Server Options, then check the Data Access box.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Sandra" <anonymous@.discussions.microsoft.com> wrote in message
news:00db01c3d620$c2708f40$a601280a@.phx.gbl...
I need to load data from a table in sqlserver to a table
in an instance of the same server. The query need to be
run in the SQL server itself not in the instance. So...
insert into [servername\instancename].[dbname].
[dbo].table1 (
col1,
col2)
select
t2.col1,
t2.col2
from table2 as t2
I keep getting this message:
Server 'CNS-SFO-A46\QA' is not configured for DATA ACCESS.
Thanks in advance for you help.
--=_NextPart_000_038B_01C3D5F9.27781520
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
In Enterprise Mgr, right click on the =linked server - CNS-SFO-A46\QA. Bring up the properties, =click on Server Options, then check the Data Access box.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Sandra" wrote in message news:00db01c3d620$c2=708f40$a601280a@.phx.gbl...I need to load data from a table in sqlserver to a table in an =instance of the same server. The query need to be run in the SQL server itself not =in the instance. So...insert into [servername\instancename].[dbname].[dbo].table1 (col1,col2)selectt2.col1,t2.col2from table2 as =t2 I keep getting this message:Server 'CNS-SFO-A46\QA' is =not configured for DATA ACCESS.Thanks in advance for you =help.
--=_NextPart_000_038B_01C3D5F9.27781520--|||I'm affraid I don't see a check box for Data Access. Is it
possible I'm looking in the wrong place?
>--Original Message--
>In Enterprise Mgr, right click on the linked server - CNS-
SFO-A46\QA. Bring
>up the properties, click on Server Options, then check
the Data Access box.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Sandra" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00db01c3d620$c2708f40$a601280a@.phx.gbl...
>I need to load data from a table in sqlserver to a table
>in an instance of the same server. The query need to be
>run in the SQL server itself not in the instance. So...
>insert into [servername\instancename].[dbname].
>[dbo].table1 (
>col1,
>col2)
>select
>t2.col1,
>t2.col2
>from table2 as t2
>I keep getting this message:
>Server 'CNS-SFO-A46\QA' is not configured for DATA ACCESS.
>Thanks in advance for you help.
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0038_01C3D60C.8C53A730
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Did you find the linked server under Security->Linked Servers?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Sandra" <anonymous@.discussions.microsoft.com> wrote in message
news:058101c3d631$7e232580$a101280a@.phx.gbl...
I'm affraid I don't see a check box for Data Access. Is it
possible I'm looking in the wrong place?
>--Original Message--
>In Enterprise Mgr, right click on the linked server - CNS-
SFO-A46\QA. Bring
>up the properties, click on Server Options, then check
the Data Access box.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Sandra" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00db01c3d620$c2708f40$a601280a@.phx.gbl...
>I need to load data from a table in sqlserver to a table
>in an instance of the same server. The query need to be
>run in the SQL server itself not in the instance. So...
>insert into [servername\instancename].[dbname].
>[dbo].table1 (
>col1,
>col2)
>select
>t2.col1,
>t2.col2
>from table2 as t2
>I keep getting this message:
>Server 'CNS-SFO-A46\QA' is not configured for DATA ACCESS.
>Thanks in advance for you help.
>
--=_NextPart_000_0038_01C3D60C.8C53A730
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Did you find the linked server under Security->Linked Servers?
-- Tom
----Thomas A. =Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql.
"Sandra" wrote in message news:058101c3d631$7e=232580$a101280a@.phx.gbl...I'm affraid I don't see a check box for Data Access. Is it possible I'm =looking in the wrong place?>--Original Message-->In =Enterprise Mgr, right click on the linked server - CNS-SFO-A46\QA. Bring>up the properties, click on Server Options, then check =the Data Access box.>>-->Tom>>--=---->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server MVP>Columnist, =SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"Sand=ra" wrote in message>news:00db01c3d620$c2708f40$a601280a@.phx.gbl...>=I need to load data from a table in sqlserver to a table>in an instance =of the same server. The query need to be>run in the SQL server itself =not in the instance. So...>>insert into [servername\instancename].[dbname].>[dbo].table1 (>col1,>col2)>select>t2.col1,>t2.col2>from table2 as t2>>I keep getting this =message:>>Server 'CNS-SFO-A46\QA' is not configured for DATA =ACCESS.>>Thanks in advance for you help.>
--=_NextPart_000_0038_01C3D60C.8C53A730--|||Yes, I did and I don't find the name of the server listed
but when I try to create New Linked Server it says the
server already exist. The same response I get when I try
to run EXEC sp_addlinkedserver
@.server = 'servername\instancename'
Also, I see the name of the server in the sysservers table.
>--Original Message--
>Did you find the linked server under Security->Linked
Servers?
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>..
>"Sandra" <anonymous@.discussions.microsoft.com> wrote in
message
>news:058101c3d631$7e232580$a101280a@.phx.gbl...
>I'm affraid I don't see a check box for Data Access. Is it
>possible I'm looking in the wrong place?
>>--Original Message--
>>In Enterprise Mgr, right click on the linked server -
CNS-
>SFO-A46\QA. Bring
>>up the properties, click on Server Options, then check
>the Data Access box.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Sandra" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:00db01c3d620$c2708f40$a601280a@.phx.gbl...
>>I need to load data from a table in sqlserver to a table
>>in an instance of the same server. The query need to be
>>run in the SQL server itself not in the instance. So...
>>insert into [servername\instancename].[dbname].
>>[dbo].table1 (
>>col1,
>>col2)
>>select
>>t2.col1,
>>t2.col2
>>from table2 as t2
>>I keep getting this message:
>>Server 'CNS-SFO-A46\QA' is not configured for DATA
ACCESS.
>>Thanks in advance for you help.
>|||The server might already be listed under "remote servers". This would happen
for example if you were doing replication from one instance to another. You
can allow data access by running the procedure
sp_serveroption 'server' ,
'data access',
'true'
Hope this helps,
Joe Lax
<anonymous@.discussions.microsoft.com> wrote in message
news:06be01c3d641$bbad9740$a101280a@.phx.gbl...
> Yes, I did and I don't find the name of the server listed
> but when I try to create New Linked Server it says the
> server already exist. The same response I get when I try
> to run EXEC sp_addlinkedserver
> @.server = 'servername\instancename'
> Also, I see the name of the server in the sysservers table.
>
>
> >--Original Message--
> >Did you find the linked server under Security->Linked
> Servers?
> >
> >--
> > Tom
> >
> >----
> >Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >SQL Server MVP
> >Columnist, SQL Server Professional
> >Toronto, ON Canada
> >www.pinnaclepublishing.com/sql
> >..
> >"Sandra" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:058101c3d631$7e232580$a101280a@.phx.gbl...
> >I'm affraid I don't see a check box for Data Access. Is it
> >possible I'm looking in the wrong place?
> >
> >>--Original Message--
> >>In Enterprise Mgr, right click on the linked server -
> CNS-
> >SFO-A46\QA. Bring
> >>up the properties, click on Server Options, then check
> >the Data Access box.
> >>
> >>--
> >>Tom
> >>
> >>----
> -
> >--
> >>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >>SQL Server MVP
> >>Columnist, SQL Server Professional
> >>Toronto, ON Canada
> >>www.pinnaclepublishing.com/sql
> >>
> >>
> >>"Sandra" <anonymous@.discussions.microsoft.com> wrote in
> >message
> >>news:00db01c3d620$c2708f40$a601280a@.phx.gbl...
> >>I need to load data from a table in sqlserver to a table
> >>in an instance of the same server. The query need to be
> >>run in the SQL server itself not in the instance. So...
> >>
> >>insert into [servername\instancename].[dbname].
> >>[dbo].table1 (
> >>col1,
> >>col2)
> >>select
> >>t2.col1,
> >>t2.col2
> >>from table2 as t2
> >>
> >>I keep getting this message:
> >>
> >>Server 'CNS-SFO-A46\QA' is not configured for DATA
> ACCESS.
> >>
> >>Thanks in advance for you help.
> >>
> >sql
Showing posts with label instance. Show all posts
Showing posts with label instance. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
Listing Available SQL Servers
How does a machine know what SQL servers are available.
For instance: when I create a data link using OLE DB there
is a ComboBox that lists all of the available SQL Servers
to connect to. How does this list get generated and
refreshed? I ask this because I see a particular server in
the list on my PC but I have a coworker whose list does
not contain the server.Doug,
'Enumerate SQL Servers using OLE-DB'
http://sqldev.net/misc/OleDbEnum.htm
'Enumerate SQL Servers in a domain using the LAN Manager API
NetServerEnum().'
http://sqldev.net/misc/EnumSQLSvr.htm
'Enumerate SQL Server instances on the network using the ODBC
SQLBrowseConnect functionality'
http://sqldev.net/misc/ListSQLSvr.htm
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Doug" <carrd@.firstenergycorp.com> wrote in message
news:982501c433ad$4c706690$a101280a@.phx.gbl...
> How does a machine know what SQL servers are available.
> For instance: when I create a data link using OLE DB there
> is a ComboBox that lists all of the available SQL Servers
> to connect to. How does this list get generated and
> refreshed? I ask this because I see a particular server in
> the list on my PC but I have a coworker whose list does
> not contain the server.
For instance: when I create a data link using OLE DB there
is a ComboBox that lists all of the available SQL Servers
to connect to. How does this list get generated and
refreshed? I ask this because I see a particular server in
the list on my PC but I have a coworker whose list does
not contain the server.Doug,
'Enumerate SQL Servers using OLE-DB'
http://sqldev.net/misc/OleDbEnum.htm
'Enumerate SQL Servers in a domain using the LAN Manager API
NetServerEnum().'
http://sqldev.net/misc/EnumSQLSvr.htm
'Enumerate SQL Server instances on the network using the ODBC
SQLBrowseConnect functionality'
http://sqldev.net/misc/ListSQLSvr.htm
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Doug" <carrd@.firstenergycorp.com> wrote in message
news:982501c433ad$4c706690$a101280a@.phx.gbl...
> How does a machine know what SQL servers are available.
> For instance: when I create a data link using OLE DB there
> is a ComboBox that lists all of the available SQL Servers
> to connect to. How does this list get generated and
> refreshed? I ask this because I see a particular server in
> the list on my PC but I have a coworker whose list does
> not contain the server.
Listing Available SQL Servers
How does a machine know what SQL servers are available.
For instance: when I create a data link using OLE DB there
is a ComboBox that lists all of the available SQL Servers
to connect to. How does this list get generated and
refreshed? I ask this because I see a particular server in
the list on my PC but I have a coworker whose list does
not contain the server.
Doug,
'Enumerate SQL Servers using OLE-DB'
http://sqldev.net/misc/OleDbEnum.htm
'Enumerate SQL Servers in a domain using the LAN Manager API
NetServerEnum().'
http://sqldev.net/misc/EnumSQLSvr.htm
'Enumerate SQL Server instances on the network using the ODBC
SQLBrowseConnect functionality'
http://sqldev.net/misc/ListSQLSvr.htm
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Doug" <carrd@.firstenergycorp.com> wrote in message
news:982501c433ad$4c706690$a101280a@.phx.gbl...
> How does a machine know what SQL servers are available.
> For instance: when I create a data link using OLE DB there
> is a ComboBox that lists all of the available SQL Servers
> to connect to. How does this list get generated and
> refreshed? I ask this because I see a particular server in
> the list on my PC but I have a coworker whose list does
> not contain the server.
sql
For instance: when I create a data link using OLE DB there
is a ComboBox that lists all of the available SQL Servers
to connect to. How does this list get generated and
refreshed? I ask this because I see a particular server in
the list on my PC but I have a coworker whose list does
not contain the server.
Doug,
'Enumerate SQL Servers using OLE-DB'
http://sqldev.net/misc/OleDbEnum.htm
'Enumerate SQL Servers in a domain using the LAN Manager API
NetServerEnum().'
http://sqldev.net/misc/EnumSQLSvr.htm
'Enumerate SQL Server instances on the network using the ODBC
SQLBrowseConnect functionality'
http://sqldev.net/misc/ListSQLSvr.htm
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Doug" <carrd@.firstenergycorp.com> wrote in message
news:982501c433ad$4c706690$a101280a@.phx.gbl...
> How does a machine know what SQL servers are available.
> For instance: when I create a data link using OLE DB there
> is a ComboBox that lists all of the available SQL Servers
> to connect to. How does this list get generated and
> refreshed? I ask this because I see a particular server in
> the list on my PC but I have a coworker whose list does
> not contain the server.
sql
Monday, March 19, 2012
ListAvailableSQLServers
I have a VB6 app that uses ListAvailableSQLServers to collect the server names on a computer. On Windows XP, however, the default instance shows up as (LOCAL) while @.@.servername is the computername. When my app tries to select from (LOCAL).db.dbo.table, it gets "SQL Server does not exist or access is denied." If it selects from "computer".db.dbo.table all is well.
Any thoughts how to get around this? Aliasing does not work...
Thanks in advance.Plz first make sure the SQL service is running by checking it under the Services group in the Management console and what startup service account it's using; can u connect to that instance thru Query Analyzer? If yes then type in
select serverproperty('servername').
Check the mode of Authentication u r tryin to connect to SQL thru. Post some details about the startup-service account etc.
Howdy.|||Since the (local) server is nearly "hardwired" into the list, there isn't a good way to avoid it. The machine name should still appear in the list anyway. I usually just put in code to ignore both the IP address and the constant (local) as I iterate through the list of servers.
-PatP|||Sorry, SPE (Stupid Programmer Error); one of my ADO connection strings had the data source hardcoded (leftover from testing). Thanks both...|||Hmmm... We know those as ID10T errors. Same difference!
Glad you are working now!
-PatP
Any thoughts how to get around this? Aliasing does not work...
Thanks in advance.Plz first make sure the SQL service is running by checking it under the Services group in the Management console and what startup service account it's using; can u connect to that instance thru Query Analyzer? If yes then type in
select serverproperty('servername').
Check the mode of Authentication u r tryin to connect to SQL thru. Post some details about the startup-service account etc.
Howdy.|||Since the (local) server is nearly "hardwired" into the list, there isn't a good way to avoid it. The machine name should still appear in the list anyway. I usually just put in code to ignore both the IP address and the constant (local) as I iterate through the list of servers.
-PatP|||Sorry, SPE (Stupid Programmer Error); one of my ADO connection strings had the data source hardcoded (leftover from testing). Thanks both...|||Hmmm... We know those as ID10T errors. Same difference!
Glad you are working now!
-PatP
list SQL servers in a domain
Hi,
I am searching for a tool that list all SQL-servers in a domain or subnet
(servername, instance, SQL version, SQL Edition, SP level). Does anybody know
such software?
Thanks for your help
TillTake a look at the tools on www.sqlsecurity.com
Linchi
"Till Skidzun" wrote:
> Hi,
> I am searching for a tool that list all SQL-servers in a domain or subnet
> (servername, instance, SQL version, SQL Edition, SP level). Does anybody know
> such software?
> Thanks for your help
> Till
I am searching for a tool that list all SQL-servers in a domain or subnet
(servername, instance, SQL version, SQL Edition, SP level). Does anybody know
such software?
Thanks for your help
TillTake a look at the tools on www.sqlsecurity.com
Linchi
"Till Skidzun" wrote:
> Hi,
> I am searching for a tool that list all SQL-servers in a domain or subnet
> (servername, instance, SQL version, SQL Edition, SP level). Does anybody know
> such software?
> Thanks for your help
> Till
list SQL servers in a domain
Hi,
I am searching for a tool that list all SQL-servers in a domain or subnet
(servername, instance, SQL version, SQL Edition, SP level). Does anybody know
such software?
Thanks for your help
Till
Take a look at the tools on www.sqlsecurity.com
Linchi
"Till Skidzun" wrote:
> Hi,
> I am searching for a tool that list all SQL-servers in a domain or subnet
> (servername, instance, SQL version, SQL Edition, SP level). Does anybody know
> such software?
> Thanks for your help
> Till
I am searching for a tool that list all SQL-servers in a domain or subnet
(servername, instance, SQL version, SQL Edition, SP level). Does anybody know
such software?
Thanks for your help
Till
Take a look at the tools on www.sqlsecurity.com
Linchi
"Till Skidzun" wrote:
> Hi,
> I am searching for a tool that list all SQL-servers in a domain or subnet
> (servername, instance, SQL version, SQL Edition, SP level). Does anybody know
> such software?
> Thanks for your help
> Till
list SQL servers in a domain
Hi,
I am searching for a tool that list all SQL-servers in a domain or subnet
(servername, instance, SQL version, SQL Edition, SP level). Does anybody kno
w
such software?
Thanks for your help
TillTake a look at the tools on www.sqlsecurity.com
Linchi
"Till Skidzun" wrote:
> Hi,
> I am searching for a tool that list all SQL-servers in a domain or subnet
> (servername, instance, SQL version, SQL Edition, SP level). Does anybody k
now
> such software?
> Thanks for your help
> Till
I am searching for a tool that list all SQL-servers in a domain or subnet
(servername, instance, SQL version, SQL Edition, SP level). Does anybody kno
w
such software?
Thanks for your help
TillTake a look at the tools on www.sqlsecurity.com
Linchi
"Till Skidzun" wrote:
> Hi,
> I am searching for a tool that list all SQL-servers in a domain or subnet
> (servername, instance, SQL version, SQL Edition, SP level). Does anybody k
now
> such software?
> Thanks for your help
> Till
Friday, March 9, 2012
List of SQL Server 7.0/2000 instances running
How to get the list of instance of SQL Server 7.0/2000 running on the local machine inside my domain...
I need to prepare the list of all sql instances.. pls help if possible to find details using sql query.I'd start with:EXECUTE master.dbo.xp_cmdshell 'osql -L'You might have to refine it a bit, but it is a place to start.
-PatP
I need to prepare the list of all sql instances.. pls help if possible to find details using sql query.I'd start with:EXECUTE master.dbo.xp_cmdshell 'osql -L'You might have to refine it a bit, but it is a place to start.
-PatP
Friday, February 24, 2012
List databases and size of an instance or sql server
Hi all
I looking the way to list the all the databases in a server and get other
properites such the size of each one.
The list of the databases of are in the master databaes, select name from
sysdatabases, but the other properties are inside on each databes (size,
last backup...) How i can use the select like a variable to connect to the
rest of the databases in the server o instance?
Best Regards
FernandoHi,
Execute the below system procedure from query analyzer:-
sp_helpdb
Thanks
Hari
SQL Server mvp
"Nano" <Nano@.discussions.microsoft.com> wrote in message
news:86D15A09-972A-4D12-8893-D3FE79C4FCFC@.microsoft.com...
> Hi all
> I looking the way to list the all the databases in a server and get other
> properites such the size of each one.
> The list of the databases of are in the master databaes, select name from
> sysdatabases, but the other properties are inside on each databes (size,
> last backup...) How i can use the select like a variable to connect to the
> rest of the databases in the server o instance?
> Best Regards
> Fernando
I looking the way to list the all the databases in a server and get other
properites such the size of each one.
The list of the databases of are in the master databaes, select name from
sysdatabases, but the other properties are inside on each databes (size,
last backup...) How i can use the select like a variable to connect to the
rest of the databases in the server o instance?
Best Regards
FernandoHi,
Execute the below system procedure from query analyzer:-
sp_helpdb
Thanks
Hari
SQL Server mvp
"Nano" <Nano@.discussions.microsoft.com> wrote in message
news:86D15A09-972A-4D12-8893-D3FE79C4FCFC@.microsoft.com...
> Hi all
> I looking the way to list the all the databases in a server and get other
> properites such the size of each one.
> The list of the databases of are in the master databaes, select name from
> sysdatabases, but the other properties are inside on each databes (size,
> last backup...) How i can use the select like a variable to connect to the
> rest of the databases in the server o instance?
> Best Regards
> Fernando
List both SQL2000&2005 instance using SQLDMO
I have C++ application which can list all registered SQL Server in your local machine. The problem is this app can't list SQL server 2005 instance.
How can I list both SQL2000 and 2005 server instance using SQLDMO?
Thanks
Have you installed the SQL 2005 workstation components? There is an updated version of SQLDMO which supports SQL Server 2005. The DMO dll's that came with SQL Server 2000 won't be able to read SQL 2005 server information, but the 2005 DMO dll's should solve your problem.
List available SQL instances in a Server
Hi, iam using this script to connect to the default instance of a SQL Server
(7 or 2000)
strcomputer = wscript.arguments(0)
Set oServer=CreateObject("SQLDMO.Sqlserver")
oserver.loginsecure = true
oServer.Connect strComputer
The problem is:
When i try to connect to a server that has many instances
(MSSQLSERVER$XXXXXX) i cant connect. This scripts only works with the defaul
t
mssqlserver. The question is how can connect to a server and list the
available instances instead of hardcoding in code (Like strcomputer &
"\Instance") using vbscript or other shell tool. (The discover tool like osq
l
-L doesn't work, because it cant detect server over lot of networks)
Thanks all.Use the ListAvailableServers Method of the application object.
INF: How to Enumerate Available SQL Servers Using SQLDMO
http://support.microsoft.com/defaul...b;en-us;Q287737
AMB
"Tinchos" wrote:
> Hi, iam using this script to connect to the default instance of a SQL Serv
er
> (7 or 2000)
> strcomputer = wscript.arguments(0)
> Set oServer=CreateObject("SQLDMO.Sqlserver")
> oserver.loginsecure = true
> oServer.Connect strComputer
> The problem is:
> When i try to connect to a server that has many instances
> (MSSQLSERVER$XXXXXX) i cant connect. This scripts only works with the defa
ult
> mssqlserver. The question is how can connect to a server and list the
> available instances instead of hardcoding in code (Like strcomputer &
> "\Instance") using vbscript or other shell tool. (The discover tool like o
sql
> -L doesn't work, because it cant detect server over lot of networks)
> Thanks all.|||Thanks Alejandro. But it doesn't work neither. It's the same that use the
osql -L (only works on local network)
I need to find a method to connect to a server and list the available
instances with dmo.
Thanks !!
"Alejandro Mesa" wrote:
> Use the ListAvailableServers Method of the application object.
> INF: How to Enumerate Available SQL Servers Using SQLDMO
> http://support.microsoft.com/defaul...b;en-us;Q287737
>
> AMB
> "Tinchos" wrote:
>|||See if querying master.dbo.sysservers or executing sp_helpserver helps.
AMB
"Tinchos" wrote:
> Thanks Alejandro. But it doesn't work neither. It's the same that use the
> osql -L (only works on local network)
> I need to find a method to connect to a server and list the available
> instances with dmo.
> Thanks !!
> "Alejandro Mesa" wrote:
>|||Nop, i have a about 50 sql server over the network.
New sql servers are installed with instances, like this:
SERVER\UNLAMXEX
SERVER\UNLAMXFO
SERVER\UNLAMXPR
I need to specify the instance to connect with isql o other. I need some
scripting tool to detects automatically the instances.
Thanks.
Martin
"Alejandro Mesa" wrote:
> See if querying master.dbo.sysservers or executing sp_helpserver helps.
>
> AMB
> "Tinchos" wrote:
>
(7 or 2000)
strcomputer = wscript.arguments(0)
Set oServer=CreateObject("SQLDMO.Sqlserver")
oserver.loginsecure = true
oServer.Connect strComputer
The problem is:
When i try to connect to a server that has many instances
(MSSQLSERVER$XXXXXX) i cant connect. This scripts only works with the defaul
t
mssqlserver. The question is how can connect to a server and list the
available instances instead of hardcoding in code (Like strcomputer &
"\Instance") using vbscript or other shell tool. (The discover tool like osq
l
-L doesn't work, because it cant detect server over lot of networks)
Thanks all.Use the ListAvailableServers Method of the application object.
INF: How to Enumerate Available SQL Servers Using SQLDMO
http://support.microsoft.com/defaul...b;en-us;Q287737
AMB
"Tinchos" wrote:
> Hi, iam using this script to connect to the default instance of a SQL Serv
er
> (7 or 2000)
> strcomputer = wscript.arguments(0)
> Set oServer=CreateObject("SQLDMO.Sqlserver")
> oserver.loginsecure = true
> oServer.Connect strComputer
> The problem is:
> When i try to connect to a server that has many instances
> (MSSQLSERVER$XXXXXX) i cant connect. This scripts only works with the defa
ult
> mssqlserver. The question is how can connect to a server and list the
> available instances instead of hardcoding in code (Like strcomputer &
> "\Instance") using vbscript or other shell tool. (The discover tool like o
sql
> -L doesn't work, because it cant detect server over lot of networks)
> Thanks all.|||Thanks Alejandro. But it doesn't work neither. It's the same that use the
osql -L (only works on local network)
I need to find a method to connect to a server and list the available
instances with dmo.
Thanks !!
"Alejandro Mesa" wrote:
> Use the ListAvailableServers Method of the application object.
> INF: How to Enumerate Available SQL Servers Using SQLDMO
> http://support.microsoft.com/defaul...b;en-us;Q287737
>
> AMB
> "Tinchos" wrote:
>|||See if querying master.dbo.sysservers or executing sp_helpserver helps.
AMB
"Tinchos" wrote:
> Thanks Alejandro. But it doesn't work neither. It's the same that use the
> osql -L (only works on local network)
> I need to find a method to connect to a server and list the available
> instances with dmo.
> Thanks !!
> "Alejandro Mesa" wrote:
>|||Nop, i have a about 50 sql server over the network.
New sql servers are installed with instances, like this:
SERVER\UNLAMXEX
SERVER\UNLAMXFO
SERVER\UNLAMXPR
I need to specify the instance to connect with isql o other. I need some
scripting tool to detects automatically the instances.
Thanks.
Martin
"Alejandro Mesa" wrote:
> See if querying master.dbo.sysservers or executing sp_helpserver helps.
>
> AMB
> "Tinchos" wrote:
>
Subscribe to:
Posts (Atom)