I am receiving the following error when attempting to drop a server to rename
it
Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server, Line
39
Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
replication.
Replication is not occuring on this server.
When I execute sp_get_distributor the results show that replication is not
occuring on this server.
Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
My question is should I delete the record that is in this table to allow
renaming of the server?
It is possible this server has a remote distributor. Issue a call to
sp_helpdistributor to get the server which is acting as the distributor's
name.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>I am receiving the following error when attempting to drop a server to
>rename
> it
> Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
> Line
> 39
> Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
> replication.
> Replication is not occuring on this server.
> When I execute sp_get_distributor the results show that replication is not
> occuring on this server.
> Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
> My question is should I delete the record that is in this table to allow
> renaming of the server?
>
|||Thanks for the response.
This server does not have a remote distributor. sp_helpdistributor returns
no rows
I believe that this server was set up for replication at some time in the
past, and that the person who did this (no longer with the company) did not
do it properly or clean up after himself.
I believe that by removing the entries in msdb.dbo.MSdistpublishers and
msdb.dbo.MSdistributiondbs I can rename the server.
I just wanted some verification prior to doing this.
Thanks
"Hilary Cotter" wrote:
> It is possible this server has a remote distributor. Issue a call to
> sp_helpdistributor to get the server which is acting as the distributor's
> name.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
> news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>
>
|||I would not attempt it that way. I would re-enable replication and then
disable it. This normally cleans up inconsistent metadata.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:28AFB311-60CD-4AB9-A29E-FD0D2BD805BD@.microsoft.com...[vbcol=seagreen]
> Thanks for the response.
> This server does not have a remote distributor. sp_helpdistributor
> returns
> no rows
> I believe that this server was set up for replication at some time in the
> past, and that the person who did this (no longer with the company) did
> not
> do it properly or clean up after himself.
> I believe that by removing the entries in msdb.dbo.MSdistpublishers and
> msdb.dbo.MSdistributiondbs I can rename the server.
> I just wanted some verification prior to doing this.
> Thanks
> "Hilary Cotter" wrote:
Showing posts with label receiving. Show all posts
Showing posts with label receiving. Show all posts
Sunday, March 25, 2012
Cannot Drop Server
I am receiving the following error when attempting to drop a server to renam
e
it
Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server, Line
39
Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
replication.
Replication is not occuring on this server.
When I execute sp_get_distributor the results show that replication is not
occuring on this server.
Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
My question is should I delete the record that is in this table to allow
renaming of the server?It is possible this server has a remote distributor. Issue a call to
sp_helpdistributor to get the server which is acting as the distributor's
name.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>I am receiving the following error when attempting to drop a server to
>rename
> it
> Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
> Line
> 39
> Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
> replication.
> Replication is not occuring on this server.
> When I execute sp_get_distributor the results show that replication is not
> occuring on this server.
> Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
> My question is should I delete the record that is in this table to allow
> renaming of the server?
>|||Thanks for the response.
This server does not have a remote distributor. sp_helpdistributor returns
no rows
I believe that this server was set up for replication at some time in the
past, and that the person who did this (no longer with the company) did not
do it properly or clean up after himself.
I believe that by removing the entries in msdb.dbo.MSdistpublishers and
msdb.dbo.MSdistributiondbs I can rename the server.
I just wanted some verification prior to doing this.
Thanks
"Hilary Cotter" wrote:
> It is possible this server has a remote distributor. Issue a call to
> sp_helpdistributor to get the server which is acting as the distributor's
> name.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
> news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>
>|||I would not attempt it that way. I would re-enable replication and then
disable it. This normally cleans up inconsistent metadata.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:28AFB311-60CD-4AB9-A29E-FD0D2BD805BD@.microsoft.com...[vbcol=seagreen]
> Thanks for the response.
> This server does not have a remote distributor. sp_helpdistributor
> returns
> no rows
> I believe that this server was set up for replication at some time in the
> past, and that the person who did this (no longer with the company) did
> not
> do it properly or clean up after himself.
> I believe that by removing the entries in msdb.dbo.MSdistpublishers and
> msdb.dbo.MSdistributiondbs I can rename the server.
> I just wanted some verification prior to doing this.
> Thanks
> "Hilary Cotter" wrote:
>
e
it
Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server, Line
39
Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
replication.
Replication is not occuring on this server.
When I execute sp_get_distributor the results show that replication is not
occuring on this server.
Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
My question is should I delete the record that is in this table to allow
renaming of the server?It is possible this server has a remote distributor. Issue a call to
sp_helpdistributor to get the server which is acting as the distributor's
name.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>I am receiving the following error when attempting to drop a server to
>rename
> it
> Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
> Line
> 39
> Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
> replication.
> Replication is not occuring on this server.
> When I execute sp_get_distributor the results show that replication is not
> occuring on this server.
> Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
> My question is should I delete the record that is in this table to allow
> renaming of the server?
>|||Thanks for the response.
This server does not have a remote distributor. sp_helpdistributor returns
no rows
I believe that this server was set up for replication at some time in the
past, and that the person who did this (no longer with the company) did not
do it properly or clean up after himself.
I believe that by removing the entries in msdb.dbo.MSdistpublishers and
msdb.dbo.MSdistributiondbs I can rename the server.
I just wanted some verification prior to doing this.
Thanks
"Hilary Cotter" wrote:
> It is possible this server has a remote distributor. Issue a call to
> sp_helpdistributor to get the server which is acting as the distributor's
> name.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
> news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>
>|||I would not attempt it that way. I would re-enable replication and then
disable it. This normally cleans up inconsistent metadata.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:28AFB311-60CD-4AB9-A29E-FD0D2BD805BD@.microsoft.com...[vbcol=seagreen]
> Thanks for the response.
> This server does not have a remote distributor. sp_helpdistributor
> returns
> no rows
> I believe that this server was set up for replication at some time in the
> past, and that the person who did this (no longer with the company) did
> not
> do it properly or clean up after himself.
> I believe that by removing the entries in msdb.dbo.MSdistpublishers and
> msdb.dbo.MSdistributiondbs I can rename the server.
> I just wanted some verification prior to doing this.
> Thanks
> "Hilary Cotter" wrote:
>
Cannot Drop Server
I am receiving the following error when attempting to drop a server to rename
it
Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server, Line
39
Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
replication.
Replication is not occuring on this server.
When I execute sp_get_distributor the results show that replication is not
occuring on this server.
Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
My question is should I delete the record that is in this table to allow
renaming of the server?It is possible this server has a remote distributor. Issue a call to
sp_helpdistributor to get the server which is acting as the distributor's
name.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>I am receiving the following error when attempting to drop a server to
>rename
> it
> Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
> Line
> 39
> Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
> replication.
> Replication is not occuring on this server.
> When I execute sp_get_distributor the results show that replication is not
> occuring on this server.
> Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
> My question is should I delete the record that is in this table to allow
> renaming of the server?
>|||Thanks for the response.
This server does not have a remote distributor. sp_helpdistributor returns
no rows
I believe that this server was set up for replication at some time in the
past, and that the person who did this (no longer with the company) did not
do it properly or clean up after himself.
I believe that by removing the entries in msdb.dbo.MSdistpublishers and
msdb.dbo.MSdistributiondbs I can rename the server.
I just wanted some verification prior to doing this.
Thanks
"Hilary Cotter" wrote:
> It is possible this server has a remote distributor. Issue a call to
> sp_helpdistributor to get the server which is acting as the distributor's
> name.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
> news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
> >I am receiving the following error when attempting to drop a server to
> >rename
> > it
> >
> > Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
> > Line
> > 39
> > Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
> > replication.
> >
> > Replication is not occuring on this server.
> > When I execute sp_get_distributor the results show that replication is not
> > occuring on this server.
> >
> > Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
> > My question is should I delete the record that is in this table to allow
> > renaming of the server?
> >
>
>|||I would not attempt it that way. I would re-enable replication and then
disable it. This normally cleans up inconsistent metadata.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:28AFB311-60CD-4AB9-A29E-FD0D2BD805BD@.microsoft.com...
> Thanks for the response.
> This server does not have a remote distributor. sp_helpdistributor
> returns
> no rows
> I believe that this server was set up for replication at some time in the
> past, and that the person who did this (no longer with the company) did
> not
> do it properly or clean up after himself.
> I believe that by removing the entries in msdb.dbo.MSdistpublishers and
> msdb.dbo.MSdistributiondbs I can rename the server.
> I just wanted some verification prior to doing this.
> Thanks
> "Hilary Cotter" wrote:
>> It is possible this server has a remote distributor. Issue a call to
>> sp_helpdistributor to get the server which is acting as the distributor's
>> name.
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "John Bradford" <John Bradford@.discussions.microsoft.com> wrote in
>> message
>> news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>> >I am receiving the following error when attempting to drop a server to
>> >rename
>> > it
>> >
>> > Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
>> > Line
>> > 39
>> > Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
>> > replication.
>> >
>> > Replication is not occuring on this server.
>> > When I execute sp_get_distributor the results show that replication is
>> > not
>> > occuring on this server.
>> >
>> > Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
>> > My question is should I delete the record that is in this table to
>> > allow
>> > renaming of the server?
>> >
>>sql
it
Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server, Line
39
Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
replication.
Replication is not occuring on this server.
When I execute sp_get_distributor the results show that replication is not
occuring on this server.
Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
My question is should I delete the record that is in this table to allow
renaming of the server?It is possible this server has a remote distributor. Issue a call to
sp_helpdistributor to get the server which is acting as the distributor's
name.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>I am receiving the following error when attempting to drop a server to
>rename
> it
> Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
> Line
> 39
> Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
> replication.
> Replication is not occuring on this server.
> When I execute sp_get_distributor the results show that replication is not
> occuring on this server.
> Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
> My question is should I delete the record that is in this table to allow
> renaming of the server?
>|||Thanks for the response.
This server does not have a remote distributor. sp_helpdistributor returns
no rows
I believe that this server was set up for replication at some time in the
past, and that the person who did this (no longer with the company) did not
do it properly or clean up after himself.
I believe that by removing the entries in msdb.dbo.MSdistpublishers and
msdb.dbo.MSdistributiondbs I can rename the server.
I just wanted some verification prior to doing this.
Thanks
"Hilary Cotter" wrote:
> It is possible this server has a remote distributor. Issue a call to
> sp_helpdistributor to get the server which is acting as the distributor's
> name.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
> news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
> >I am receiving the following error when attempting to drop a server to
> >rename
> > it
> >
> > Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
> > Line
> > 39
> > Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
> > replication.
> >
> > Replication is not occuring on this server.
> > When I execute sp_get_distributor the results show that replication is not
> > occuring on this server.
> >
> > Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
> > My question is should I delete the record that is in this table to allow
> > renaming of the server?
> >
>
>|||I would not attempt it that way. I would re-enable replication and then
disable it. This normally cleans up inconsistent metadata.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Bradford" <John Bradford@.discussions.microsoft.com> wrote in message
news:28AFB311-60CD-4AB9-A29E-FD0D2BD805BD@.microsoft.com...
> Thanks for the response.
> This server does not have a remote distributor. sp_helpdistributor
> returns
> no rows
> I believe that this server was set up for replication at some time in the
> past, and that the person who did this (no longer with the company) did
> not
> do it properly or clean up after himself.
> I believe that by removing the entries in msdb.dbo.MSdistpublishers and
> msdb.dbo.MSdistributiondbs I can rename the server.
> I just wanted some verification prior to doing this.
> Thanks
> "Hilary Cotter" wrote:
>> It is possible this server has a remote distributor. Issue a call to
>> sp_helpdistributor to get the server which is acting as the distributor's
>> name.
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "John Bradford" <John Bradford@.discussions.microsoft.com> wrote in
>> message
>> news:72F385EA-A8D7-4A6C-A8A7-DCEC184AB88A@.microsoft.com...
>> >I am receiving the following error when attempting to drop a server to
>> >rename
>> > it
>> >
>> > Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
>> > Line
>> > 39
>> > Cannot drop server 'ZHQACCTSQL' because it is used as a Publisher in
>> > replication.
>> >
>> > Replication is not occuring on this server.
>> > When I execute sp_get_distributor the results show that replication is
>> > not
>> > occuring on this server.
>> >
>> > Looking in msdb.dbo.MSdistpublishers I find an entry for this server.
>> > My question is should I delete the record that is in this table to
>> > allow
>> > renaming of the server?
>> >
>>sql
Friday, February 24, 2012
Cannot connect to SQL Server 2005
I am receiving this error while trying to connect to a SQL Server 2005
instance.
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified) (Microsoft SQL Server, Error: -1)"
The SQL Server does allow remote connections - why would this error be
coming up?
This is a very general error meaning the tool can't find a server instance
of that name. Other possible reasons are that the SQL Server Browser Service
is not running, or a firewall is blocking you.
Try running through the short connectivity tutorial at
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>I am receiving this error while trying to connect to a SQL Server 2005
> instance.
> "An error has occurred while establishing a connection to the server.
> When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (Microsoft SQL Server, Error: -1)"
> The SQL Server does allow remote connections - why would this error be
> coming up?
>
|||Rick,
This is a problem that occurs sporadically during the day. SQL Server
Browser is running. I am running SQL Server on a Virtural Server. I have
noticed today that when the problem occurs the cpu for the Virtual Server and
the Stand alone Server are both running at 100%. We currently have 4 Virtual
Servers running with 3 of them running SQL Server 2005 on the same Stand
alone Server.
"Rick Byham, (MSFT)" wrote:
> This is a very general error meaning the tool can't find a server instance
> of that name. Other possible reasons are that the SQL Server Browser Service
> is not running, or a firewall is blocking you.
> Try running through the short connectivity tutorial at
> http://msdn2.microsoft.com/en-us/library/ms345318.aspx
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>
|||Your error is probably a symptom of the 100% CPU. The "An error has occurred
while establishing a connection ..." error is very general and indicates
that the client tools can't find the SQL Server that you are asking for. In
this case, it could be that the network isn't responding because of the 100%
CPU, or the SQL Server Browser Service can't respond because of the 100%
CPU. Of course this just moves the question to why do you have 100% CPU
usage. Solve the 100% CPU, and I bet the connectivity problem will go away.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...[vbcol=seagreen]
> Rick,
> This is a problem that occurs sporadically during the day. SQL Server
> Browser is running. I am running SQL Server on a Virtural Server. I have
> noticed today that when the problem occurs the cpu for the Virtual Server
> and
> the Stand alone Server are both running at 100%. We currently have 4
> Virtual
> Servers running with 3 of them running SQL Server 2005 on the same Stand
> alone Server.
> "Rick Byham, (MSFT)" wrote:
|||I agree. See if Microsoft OneCare Defender is chewing up all of your
processor time... ;)
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:70B1ACC0-026C-46AF-B85F-E8CCECC56041@.microsoft.com...
> Your error is probably a symptom of the 100% CPU. The "An error has
> occurred while establishing a connection ..." error is very general and
> indicates that the client tools can't find the SQL Server that you are
> asking for. In this case, it could be that the network isn't responding
> because of the 100% CPU, or the SQL Server Browser Service can't respond
> because of the 100% CPU. Of course this just moves the question to why do
> you have 100% CPU usage. Solve the 100% CPU, and I bet the connectivity
> problem will go away.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...
>
instance.
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified) (Microsoft SQL Server, Error: -1)"
The SQL Server does allow remote connections - why would this error be
coming up?
This is a very general error meaning the tool can't find a server instance
of that name. Other possible reasons are that the SQL Server Browser Service
is not running, or a firewall is blocking you.
Try running through the short connectivity tutorial at
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>I am receiving this error while trying to connect to a SQL Server 2005
> instance.
> "An error has occurred while establishing a connection to the server.
> When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (Microsoft SQL Server, Error: -1)"
> The SQL Server does allow remote connections - why would this error be
> coming up?
>
|||Rick,
This is a problem that occurs sporadically during the day. SQL Server
Browser is running. I am running SQL Server on a Virtural Server. I have
noticed today that when the problem occurs the cpu for the Virtual Server and
the Stand alone Server are both running at 100%. We currently have 4 Virtual
Servers running with 3 of them running SQL Server 2005 on the same Stand
alone Server.
"Rick Byham, (MSFT)" wrote:
> This is a very general error meaning the tool can't find a server instance
> of that name. Other possible reasons are that the SQL Server Browser Service
> is not running, or a firewall is blocking you.
> Try running through the short connectivity tutorial at
> http://msdn2.microsoft.com/en-us/library/ms345318.aspx
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>
|||Your error is probably a symptom of the 100% CPU. The "An error has occurred
while establishing a connection ..." error is very general and indicates
that the client tools can't find the SQL Server that you are asking for. In
this case, it could be that the network isn't responding because of the 100%
CPU, or the SQL Server Browser Service can't respond because of the 100%
CPU. Of course this just moves the question to why do you have 100% CPU
usage. Solve the 100% CPU, and I bet the connectivity problem will go away.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...[vbcol=seagreen]
> Rick,
> This is a problem that occurs sporadically during the day. SQL Server
> Browser is running. I am running SQL Server on a Virtural Server. I have
> noticed today that when the problem occurs the cpu for the Virtual Server
> and
> the Stand alone Server are both running at 100%. We currently have 4
> Virtual
> Servers running with 3 of them running SQL Server 2005 on the same Stand
> alone Server.
> "Rick Byham, (MSFT)" wrote:
|||I agree. See if Microsoft OneCare Defender is chewing up all of your
processor time... ;)
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:70B1ACC0-026C-46AF-B85F-E8CCECC56041@.microsoft.com...
> Your error is probably a symptom of the 100% CPU. The "An error has
> occurred while establishing a connection ..." error is very general and
> indicates that the client tools can't find the SQL Server that you are
> asking for. In this case, it could be that the network isn't responding
> because of the 100% CPU, or the SQL Server Browser Service can't respond
> because of the 100% CPU. Of course this just moves the question to why do
> you have 100% CPU usage. Solve the 100% CPU, and I bet the connectivity
> problem will go away.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...
>
Sunday, February 19, 2012
Cannot connect to SQL Server 2005
I am receiving this error while trying to connect to a SQL Server 2005
instance.
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instanc
e
Specified) (Microsoft SQL Server, Error: -1)"
The SQL Server does allow remote connections - why would this error be
coming up?This is a very general error meaning the tool can't find a server instance
of that name. Other possible reasons are that the SQL Server Browser Service
is not running, or a firewall is blocking you.
Try running through the short connectivity tutorial at
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>I am receiving this error while trying to connect to a SQL Server 2005
> instance.
> "An error has occurred while establishing a connection to the server.
> When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (Microsoft SQL Server, Error: -1)"
> The SQL Server does allow remote connections - why would this error be
> coming up?
>|||Rick,
This is a problem that occurs sporadically during the day. SQL Server
Browser is running. I am running SQL Server on a Virtural Server. I have
noticed today that when the problem occurs the cpu for the Virtual Server an
d
the Stand alone Server are both running at 100%. We currently have 4 Virtual
Servers running with 3 of them running SQL Server 2005 on the same Stand
alone Server.
"Rick Byham, (MSFT)" wrote:
> This is a very general error meaning the tool can't find a server instance
> of that name. Other possible reasons are that the SQL Server Browser Servi
ce
> is not running, or a firewall is blocking you.
> Try running through the short connectivity tutorial at
> http://msdn2.microsoft.com/en-us/library/ms345318.aspx
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>|||Your error is probably a symptom of the 100% CPU. The "An error has occurred
while establishing a connection ..." error is very general and indicates
that the client tools can't find the SQL Server that you are asking for. In
this case, it could be that the network isn't responding because of the 100%
CPU, or the SQL Server Browser Service can't respond because of the 100%
CPU. Of course this just moves the question to why do you have 100% CPU
usage. Solve the 100% CPU, and I bet the connectivity problem will go away.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...[vbcol=seagreen]
> Rick,
> This is a problem that occurs sporadically during the day. SQL Server
> Browser is running. I am running SQL Server on a Virtural Server. I have
> noticed today that when the problem occurs the cpu for the Virtual Server
> and
> the Stand alone Server are both running at 100%. We currently have 4
> Virtual
> Servers running with 3 of them running SQL Server 2005 on the same Stand
> alone Server.
> "Rick Byham, (MSFT)" wrote:
>|||I agree. See if Microsoft OneCare Defender is chewing up all of your
processor time... ;)
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:70B1ACC0-026C-46AF-B85F-E8CCECC56041@.microsoft.com...
> Your error is probably a symptom of the 100% CPU. The "An error has
> occurred while establishing a connection ..." error is very general and
> indicates that the client tools can't find the SQL Server that you are
> asking for. In this case, it could be that the network isn't responding
> because of the 100% CPU, or the SQL Server Browser Service can't respond
> because of the 100% CPU. Of course this just moves the question to why do
> you have 100% CPU usage. Solve the 100% CPU, and I bet the connectivity
> problem will go away.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...
>
instance.
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instanc
e
Specified) (Microsoft SQL Server, Error: -1)"
The SQL Server does allow remote connections - why would this error be
coming up?This is a very general error meaning the tool can't find a server instance
of that name. Other possible reasons are that the SQL Server Browser Service
is not running, or a firewall is blocking you.
Try running through the short connectivity tutorial at
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>I am receiving this error while trying to connect to a SQL Server 2005
> instance.
> "An error has occurred while establishing a connection to the server.
> When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (Microsoft SQL Server, Error: -1)"
> The SQL Server does allow remote connections - why would this error be
> coming up?
>|||Rick,
This is a problem that occurs sporadically during the day. SQL Server
Browser is running. I am running SQL Server on a Virtural Server. I have
noticed today that when the problem occurs the cpu for the Virtual Server an
d
the Stand alone Server are both running at 100%. We currently have 4 Virtual
Servers running with 3 of them running SQL Server 2005 on the same Stand
alone Server.
"Rick Byham, (MSFT)" wrote:
> This is a very general error meaning the tool can't find a server instance
> of that name. Other possible reasons are that the SQL Server Browser Servi
ce
> is not running, or a firewall is blocking you.
> Try running through the short connectivity tutorial at
> http://msdn2.microsoft.com/en-us/library/ms345318.aspx
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:90D37EAC-DBE0-449D-A9C0-D39033A7CB91@.microsoft.com...
>|||Your error is probably a symptom of the 100% CPU. The "An error has occurred
while establishing a connection ..." error is very general and indicates
that the client tools can't find the SQL Server that you are asking for. In
this case, it could be that the network isn't responding because of the 100%
CPU, or the SQL Server Browser Service can't respond because of the 100%
CPU. Of course this just moves the question to why do you have 100% CPU
usage. Solve the 100% CPU, and I bet the connectivity problem will go away.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"CRush" <CRush@.discussions.microsoft.com> wrote in message
news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...[vbcol=seagreen]
> Rick,
> This is a problem that occurs sporadically during the day. SQL Server
> Browser is running. I am running SQL Server on a Virtural Server. I have
> noticed today that when the problem occurs the cpu for the Virtual Server
> and
> the Stand alone Server are both running at 100%. We currently have 4
> Virtual
> Servers running with 3 of them running SQL Server 2005 on the same Stand
> alone Server.
> "Rick Byham, (MSFT)" wrote:
>|||I agree. See if Microsoft OneCare Defender is chewing up all of your
processor time... ;)
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:70B1ACC0-026C-46AF-B85F-E8CCECC56041@.microsoft.com...
> Your error is probably a symptom of the 100% CPU. The "An error has
> occurred while establishing a connection ..." error is very general and
> indicates that the client tools can't find the SQL Server that you are
> asking for. In this case, it could be that the network isn't responding
> because of the 100% CPU, or the SQL Server Browser Service can't respond
> because of the 100% CPU. Of course this just moves the question to why do
> you have 100% CPU usage. Solve the 100% CPU, and I bet the connectivity
> problem will go away.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "CRush" <CRush@.discussions.microsoft.com> wrote in message
> news:DDB7A36A-3B49-49D4-81DF-4C1FEF24ED21@.microsoft.com...
>
Cannot connect to SQL Express db with visual c++
I've installed both SQL Server Express and Visual C++. I'm trying to connect to a SQL database, but keep receiving various errors. This is what I've done so far.
1. Eventually, I used the surface area manager to allow a remote connect.
2. The server and my development environment exist on the same virtual machine, I created with Virtual Pc.
3. I'm running Vista as my operating system.
4. My Data Source wizard looks like this:
Data Source: MS SQL Database File
Database file name: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ETS.mdf
If I use Windows Authen I get the following error:
Unable to open physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ETS_log.ldf" Operating System Error 5: (Access is Denied). An attempt to attach to an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ETS.mdf failed. A database with the same name exist , or specified file cannot be opened, or it is located on a UNC share.
If I use SQL Server Authen I get the following error:
Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.
I'm new to this. I really would like help in knowing what these errors mean and how to get pass them. But this is very, very, very, frustrating. First off, there was no instructions on allowing remote connections. I stumble upon it myself. Giving permission to the file, stumble upon myself. I spent 4 days with a You do not have permission to open file error. Didn't realize I didn't have permission.
I need a step by step on what to do. I can be emailed at gregw.energytaxsolutions@.hotmail.com if need be.
If this is in the wrong place, moderator please move to the correct area.
Redirected from visual c++ express forum to SQL Server Express forum.
In case you are disagree with the movement, please feel free to point it out so that we can have further discuss.
|||hi,
you are using the User Instance feature of SQLExpress edition and this "method" only supports Windows authenticated connections and not mixed mode connections with standard SQL Server logins...
the other problem regards the permissions on the folder containing the referenced database file... the path must be accessible by the user instance.. please read the linked article about that..
regards
|||Thank you for the direction to the article, it was really informative (although I didn't quite understand everything it was talking about). I did get the overall jist of what it was trying to tell me. I have a lot to learn. If anyone knows of a good source of where to start, I would really appreciate it.|||hi Gregw,
additional information about User Instances can be found at http://msdn2.microsoft.com/en-us/library/ms143684.aspx, http://msdn2.microsoft.com/en-us/library/ms345154.aspx, http://msdn2.microsoft.com/en-us/library/ms254504.aspx..
regards
Subscribe to:
Posts (Atom)