Hello
I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine. I
manage the DB with the MSDE Manager from Vale Software. On the machine it
self, it works fine. I can select the DB and connect as 'sa' with password.
But on every other machine in the network, I can't connect to the DB. I can
ping to the server, that's no problem. I can chose the server in MSDE
Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer') but
I always get an error message like 'Cannot find server'. On the XP machine
there is no firewall running and -of course- the SQL-Server task is started.
The port 1433 isn't blocked.
Have enyone an idea why I can connect the DB on the machine it self but not
from every other machine in the network?
Thanks a lot
Dani
It's possible that the server does not have the network connectivity library
enabled.
i don't know how re-enable it in MSDE after MSDE is already installed.
Although i know it can be done, i read it a few days ago in the MSDE2000A
readme.
If it were SQL server, i'd say use the "Server Network Utility" (i think
it's called that). In that you can enable/disable tcpip,netbios,
multiprotocol, flatulance, etc.
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lk43sFd4pjhU1@.uni-berlin.de...
> Hello
> I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine.
I
> manage the DB with the MSDE Manager from Vale Software. On the machine it
> self, it works fine. I can select the DB and connect as 'sa' with
password.
> But on every other machine in the network, I can't connect to the DB. I
can
> ping to the server, that's no problem. I can chose the server in MSDE
> Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer')
but
> I always get an error message like 'Cannot find server'. On the XP machine
> there is no firewall running and -of course- the SQL-Server task is
started.
> The port 1433 isn't blocked.
> Have enyone an idea why I can connect the DB on the machine it self but
not
> from every other machine in the network?
> Thanks a lot
> Dani
>
|||If you run svrnetcn.exe from the /Program Files/Microsoft SQL
Server/80/Tools/BINN folder it will bring up the Server network utility, you
can make sure the network libraries are enabled.
HTH
Dylan Kruger
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
> It's possible that the server does not have the network connectivity
> library
> enabled.
> i don't know how re-enable it in MSDE after MSDE is already installed.
> Although i know it can be done, i read it a few days ago in the MSDE2000A
> readme.
> If it were SQL server, i'd say use the "Server Network Utility" (i think
> it's called that). In that you can enable/disable tcpip,netbios,
> multiprotocol, flatulance, etc.
>
> "Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
> news:2lk43sFd4pjhU1@.uni-berlin.de...
> I
> password.
> can
> but
> started.
> not
>
|||Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but after
I startet again, it works fine.
1000 thanks to you...
Dani
1000 thanks
"Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> If you run svrnetcn.exe from the /Program Files/Microsoft SQL
> Server/80/Tools/BINN folder it will bring up the Server network utility,
you[vbcol=seagreen]
> can make sure the network libraries are enabled.
> HTH
> Dylan Kruger
> "Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
> news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
MSDE2000A[vbcol=seagreen]
it
>
|||It's a new feature of MSDE, that by default it doesn't act like any other
server application on earth.
Go figure.
Probably Microsoft's tired of hearing people XXXXX about being
wormed/hacked/infected, and they just say, "Fine, your XXX get's no
connectivity anymore. Suck it!"
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lmm2oFept7kU1@.uni-berlin.de...
> Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but
after[vbcol=seagreen]
> I startet again, it works fine.
> 1000 thanks to you...
> Dani
>
> 1000 thanks
> "Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
> news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> you
> MSDE2000A
think[vbcol=seagreen]
machine[vbcol=seagreen]
> it
I[vbcol=seagreen]
'DBVisualizer')[vbcol=seagreen]
but
>
|||I had a similar problem - I was not able to connect to the MSDE from
any other machine. I had tried openning the TCP/IP Port (1433) and even
shutting down the Firewall.
Eventually, I was able to able to fix the issue by adding the registry
value for "ProtocolList" under HKEY_LOCAL_MACHINE -> SOFTWARE ->
Microsoft -> MSSQLServer -> SuperSocketNetLib
But now I have a different issue. How can I connect to the MSDE
instance with DBVisualizer? I tried to create a connection but when I
try to select / edit a Driver the drop down is empty and I cannot get
one from the list that I get by hitting the Edit button.
Please help.
- manzoor
Showing posts with label helloi. Show all posts
Showing posts with label helloi. Show all posts
Sunday, March 25, 2012
Sunday, March 11, 2012
Can't Delete Job
Hello:
I've got an old job I am trying to delete from my SQL Server 2005.
Everytime I try to delete this, i get the following error:
The DELETE statement conflicted with the REFERENCE constraint
"FK_subplan_job_id". The conflict occred in the database "msdb", table
"dbo.sysmainplan_subplans", column 'job_id'.
I know what an FK is, and why the job can't be deleted, but how do I
resolve this? How can I delete this job?Greg wrote:
> Hello:
> I've got an old job I am trying to delete from my SQL Server 2005.
> Everytime I try to delete this, i get the following error:
> The DELETE statement conflicted with the REFERENCE constraint
> "FK_subplan_job_id". The conflict occred in the database "msdb", table
> "dbo.sysmainplan_subplans", column 'job_id'.
> I know what an FK is, and why the job can't be deleted, but how do I
> resolve this? How can I delete this job?
>
Was the job created by a maintenance plan? Looks like it might have
been, judging from the FK reference. You'll probably have to go through
the maintenance plan to delete the job.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Guess I believe it was -- I was using some sort of Wizard for my first
few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
I'll let you know what I find out.
-Greg
Tracy McKibben wrote:
> Greg wrote:
> Was the job created by a maintenance plan? Looks like it might have
> been, judging from the FK reference. You'll probably have to go through
> the maintenance plan to delete the job.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Greg wrote:
> Guess I believe it was -- I was using some sort of Wizard for my first
> few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
> I'll let you know what I find out.
Good man!! Leave dem wizards alone...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It was a stupid wizard thing -- geez...I think Microsoft should leave
the wizarding to Harry Potter...
Thanks for your quick and professional answer!
-Greg
Tracy McKibben wrote:
> Greg wrote:
> Good man!! Leave dem wizards alone...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
I've got an old job I am trying to delete from my SQL Server 2005.
Everytime I try to delete this, i get the following error:
The DELETE statement conflicted with the REFERENCE constraint
"FK_subplan_job_id". The conflict occred in the database "msdb", table
"dbo.sysmainplan_subplans", column 'job_id'.
I know what an FK is, and why the job can't be deleted, but how do I
resolve this? How can I delete this job?Greg wrote:
> Hello:
> I've got an old job I am trying to delete from my SQL Server 2005.
> Everytime I try to delete this, i get the following error:
> The DELETE statement conflicted with the REFERENCE constraint
> "FK_subplan_job_id". The conflict occred in the database "msdb", table
> "dbo.sysmainplan_subplans", column 'job_id'.
> I know what an FK is, and why the job can't be deleted, but how do I
> resolve this? How can I delete this job?
>
Was the job created by a maintenance plan? Looks like it might have
been, judging from the FK reference. You'll probably have to go through
the maintenance plan to delete the job.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Guess I believe it was -- I was using some sort of Wizard for my first
few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
I'll let you know what I find out.
-Greg
Tracy McKibben wrote:
> Greg wrote:
> Was the job created by a maintenance plan? Looks like it might have
> been, judging from the FK reference. You'll probably have to go through
> the maintenance plan to delete the job.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Greg wrote:
> Guess I believe it was -- I was using some sort of Wizard for my first
> few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
> I'll let you know what I find out.
Good man!! Leave dem wizards alone...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It was a stupid wizard thing -- geez...I think Microsoft should leave
the wizarding to Harry Potter...
Thanks for your quick and professional answer!
-Greg
Tracy McKibben wrote:
> Greg wrote:
> Good man!! Leave dem wizards alone...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
Wednesday, March 7, 2012
Can't create fulltextcatalogs
Hello
I have a strange problem. I'm trying to create some fulltext catalogs using
management studio 2005, and it works great. But on one table I have a
composite key (?) PRIMARY KEY(A,B), and when I rightclick table and pick
create new fulltext catalog and press next it says that no indexes are
avalible :(
Howto solve this? Mess with the table and set just A or B as primary key?
doesn't feel right to do that.
/Lassefull text indexes can't be created on composite keys. Create a unique index
on another column or add an identity column and create a unique index on
that column.
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
"Lasse Edsvik" <lasse@.nospam.com> wrote in message
news:e%23O6ppAnGHA.964@.TK2MSFTNGP05.phx.gbl...
> Hello
> I have a strange problem. I'm trying to create some fulltext catalogs
> using
> management studio 2005, and it works great. But on one table I have a
> composite key (?) PRIMARY KEY(A,B), and when I rightclick table and pick
> create new fulltext catalog and press next it says that no indexes are
> avalible :(
> Howto solve this? Mess with the table and set just A or B as primary key?
> doesn't feel right to do that.
> /Lasse
>
I have a strange problem. I'm trying to create some fulltext catalogs using
management studio 2005, and it works great. But on one table I have a
composite key (?) PRIMARY KEY(A,B), and when I rightclick table and pick
create new fulltext catalog and press next it says that no indexes are
avalible :(
Howto solve this? Mess with the table and set just A or B as primary key?
doesn't feel right to do that.
/Lassefull text indexes can't be created on composite keys. Create a unique index
on another column or add an identity column and create a unique index on
that column.
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
"Lasse Edsvik" <lasse@.nospam.com> wrote in message
news:e%23O6ppAnGHA.964@.TK2MSFTNGP05.phx.gbl...
> Hello
> I have a strange problem. I'm trying to create some fulltext catalogs
> using
> management studio 2005, and it works great. But on one table I have a
> composite key (?) PRIMARY KEY(A,B), and when I rightclick table and pick
> create new fulltext catalog and press next it says that no indexes are
> avalible :(
> Howto solve this? Mess with the table and set just A or B as primary key?
> doesn't feel right to do that.
> /Lasse
>
Tuesday, February 14, 2012
cant connect to remote db server using SQL 2005 in Vista
Hello
I use SQL 2005 - SQL Server Management Studio to connect to my hosting SQL Server to manage my database , its about 1 month which I have installed Vista and SQL 2005 its working fine in local , but today I just wanted to connect to my remote server and I got this error :
Cannot connect to <My server IP Address>
I thought its a server problem , but its not. I tested it by connecting using same SQL 2005 on a windows xp system , the problem is only in vista,
by the way its SQL 2005 SP2
what can I do to solve this probRight-click on the application and set the option to run in XP mode. Vista sucks.|||Hi,
SQL 2005 is default closed for remote connections.
On the local server, you should configure SQL Server instance and let the remote connections.
You can try the article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx for more detail
Eralper
http://www.kodyaz.com|||NO, you didn't get that,
The remote server which I am connecting to , is a SQL Server 2000 , and its working fine , I can easily connect to this server using SQL 2000 and 2005 through windows xp , the problem is that I can't connect to this server using SQL 2005 through windows Vista,
and I get "Cannot connect to <My server IP Address>"
I think this means its can't even connect to the server to check account details|||is there a firewall in vista that you need to configure?|||No , I have disabled firewall|||HI.
Make sure you can access the remote server over the network!
Check the networkprotocol you are using to connect to the remote sql.
Under the connection properties of management studio==> Network protocol; choose b/w namedpipes and tcp/ip (try switching between them).
Most likely the protocol being used is namedpipes which doesn't allow connection if the client machine is not within the domain remote server is running on or if namedpipes protocol is disabled on remote server.|||I checked each 3 connection protocol (Shared Memory , TCP/IP , namedpipes), but nothing, the same error
:(|||make sure the sql browser service is running on the remote sql server.|||I am sure that everything on the remote sql server is ok , because I easily connect to server with windows xp and sql 2005 the problem is only in windows vista and sql 2005|||somebody help me plz|||I wish we could, but this sounds like the sort of problem that we would have to be looking over your shoulder to spot. It would seem to be a problem with your operating systems, and not the database server, and thus may be outside the scope of our expertise.
Contact Microsquash, and when you do please tell them that blindman says Vista sucks.
I use SQL 2005 - SQL Server Management Studio to connect to my hosting SQL Server to manage my database , its about 1 month which I have installed Vista and SQL 2005 its working fine in local , but today I just wanted to connect to my remote server and I got this error :
Cannot connect to <My server IP Address>
I thought its a server problem , but its not. I tested it by connecting using same SQL 2005 on a windows xp system , the problem is only in vista,
by the way its SQL 2005 SP2
what can I do to solve this probRight-click on the application and set the option to run in XP mode. Vista sucks.|||Hi,
SQL 2005 is default closed for remote connections.
On the local server, you should configure SQL Server instance and let the remote connections.
You can try the article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx for more detail
Eralper
http://www.kodyaz.com|||NO, you didn't get that,
The remote server which I am connecting to , is a SQL Server 2000 , and its working fine , I can easily connect to this server using SQL 2000 and 2005 through windows xp , the problem is that I can't connect to this server using SQL 2005 through windows Vista,
and I get "Cannot connect to <My server IP Address>"
I think this means its can't even connect to the server to check account details|||is there a firewall in vista that you need to configure?|||No , I have disabled firewall|||HI.
Make sure you can access the remote server over the network!
Check the networkprotocol you are using to connect to the remote sql.
Under the connection properties of management studio==> Network protocol; choose b/w namedpipes and tcp/ip (try switching between them).
Most likely the protocol being used is namedpipes which doesn't allow connection if the client machine is not within the domain remote server is running on or if namedpipes protocol is disabled on remote server.|||I checked each 3 connection protocol (Shared Memory , TCP/IP , namedpipes), but nothing, the same error
:(|||make sure the sql browser service is running on the remote sql server.|||I am sure that everything on the remote sql server is ok , because I easily connect to server with windows xp and sql 2005 the problem is only in windows vista and sql 2005|||somebody help me plz|||I wish we could, but this sounds like the sort of problem that we would have to be looking over your shoulder to spot. It would seem to be a problem with your operating systems, and not the database server, and thus may be outside the scope of our expertise.
Contact Microsquash, and when you do please tell them that blindman says Vista sucks.
Subscribe to:
Posts (Atom)