Hi,
I have a pbm while connecting to the remote SQL server.
Recently we hired one win2003 based Dedicated server and installed SQl
server 2000. I have the sa password and the ip of the server, and when i
connect to this server from my local machine by configuring client n/w
utility, its giving me the error. like SQL server Does not exists ?
What shall i do ? i've disabled the firewall also, but not successful yet.
Also one more problem. The version i've installed is Enterprise Edition, and
will there be any problem if i uninstall it and reinstall the Standard
edition?
Thanking u in advance LaraHi
You should have no problems with un-installing Enterprise Edition and
re-installing Standard if you are not using any of the additional features
that it has. You may want to look at
http://support.microsoft.com/defaul...b;en-us;Q314546 for
transferring logins and dealing with Orphaned users if you have them. Make
sure that the new version is service packed and patched to the same level.
Backing up your database before un-installation will make sure that you have
a safe copy.
When you install the new system make sure that the correct protocols are
listed on the server's server network utilities. Check that you can ping the
server from your client and that the client also has the correct network
protocols. You may want to try SQLPing or SQLRecon to see if the server is
contactable.
John
"lara" <lara@.l.com> wrote in message
news:eOx2EApZFHA.1088@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a pbm while connecting to the remote SQL server.
> Recently we hired one win2003 based Dedicated server and installed SQl
> server 2000. I have the sa password and the ip of the server, and when i
> connect to this server from my local machine by configuring client n/w
> utility, its giving me the error. like SQL server Does not exists ?
> What shall i do ? i've disabled the firewall also, but not successful yet.
> Also one more problem. The version i've installed is Enterprise Edition,
> and
> will there be any problem if i uninstall it and reinstall the Standard
> edition?
>
> Thanking u in advance Lara
>|||I missed out the link for SQLPing and SQLRecon!
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23nvI0tqZFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hi
> You should have no problems with un-installing Enterprise Edition and
> re-installing Standard if you are not using any of the additional features
> that it has. You may want to look at
> http://support.microsoft.com/defaul...b;en-us;Q314546 for
> transferring logins and dealing with Orphaned users if you have them. Make
> sure that the new version is service packed and patched to the same level.
> Backing up your database before un-installation will make sure that you
> have a safe copy.
> When you install the new system make sure that the correct protocols are
> listed on the server's server network utilities. Check that you can ping
> the server from your client and that the client also has the correct
> network protocols. You may want to try SQLPing or SQLRecon to see if the
> server is contactable.
> John
>
> "lara" <lara@.l.com> wrote in message
> news:eOx2EApZFHA.1088@.TK2MSFTNGP14.phx.gbl...
>|||Thanks John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eNJEsvqZFHA.3572@.TK2MSFTNGP12.phx.gbl...
> I missed out the link for SQLPing and SQLRecon!
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
> John
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23nvI0tqZFHA.1404@.TK2MSFTNGP09.phx.gbl...
features
Make
level.
i
Edition,
>
Showing posts with label dedicated. Show all posts
Showing posts with label dedicated. Show all posts
Friday, March 23, 2012
Monday, March 12, 2012
patch management
Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it wa
s
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+
)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
>
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it wa
s
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+
)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
>
patch management
Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
> > Hi experts!
> >
> > Our domain has about 50+ sql servers most of them dedicated and some are
> > multi-instance
> > I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> > still scanning but output file was with 0 size and I
> > canselled the scan. What is the reason for this behavior?
> > Tried with ip ranges and it works fine
> > How to scan all domain and avoid using ip ranges bc they are so many (100+)
> > and it will be hard work.
> > Please share your experiense updating sql servers with sp and security
> > patches. Is there a useful tools for scanning and patching domain with big
> > number sql machines.
> > Thanks in advance.
> >
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
> > Hi experts!
> >
> > Our domain has about 50+ sql servers most of them dedicated and some are
> > multi-instance
> > I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> > still scanning but output file was with 0 size and I
> > canselled the scan. What is the reason for this behavior?
> > Tried with ip ranges and it works fine
> > How to scan all domain and avoid using ip ranges bc they are so many (100+)
> > and it will be hard work.
> > Please share your experiense updating sql servers with sp and security
> > patches. Is there a useful tools for scanning and patching domain with big
> > number sql machines.
> > Thanks in advance.
> >
patch management
Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.
use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>
|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.
use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>
|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
Subscribe to:
Posts (Atom)