Hey All,
I have three questions:
(a) A new guy at work needs a list of type of permissions granted to users.
I really don't want to type all of it. Is there some software that exports
the permissions in a readable format from the SQL Server?
(b) I backed up our Master Database on the SQL Server. The host name is
SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB. When
I restored the Master on this new server, I cannot open the SQL Server
connection in Enterprise manager! It says "login failed (edit registration
properties to change the login name)". I believe it's got something to do
with the change in the host name. Is this why? If so, how can I fix it? I
need to be able to restore Master on this server. I've tried all logins,
including domain admin, Sa and so on to connect.
(c) We have a computer connected to a card reader machine that makes an
entry into a table when a card is flashed in front of it. This software was
written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
Server. Sometimes, we get the error
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation. "
After reading much about it, I changed the connection string to include a
OLE DB Services = -2. This does not help either! Does anybody have a
workable solution.
Thanks for your time.
Vince
Vince wrote:
> Hey All,
> I have three questions:
> (a) A new guy at work needs a list of type of permissions granted to
> users. I really don't want to type all of it. Is there some software
> that exports the permissions in a readable format from the SQL Server?
> (b) I backed up our Master Database on the SQL Server. The host name
> is SQLSERVERA. Now, we have a new computer with the host name
> SQLSERVERB. When I restored the Master on this new server, I cannot
> open the SQL Server connection in Enterprise manager! It says "login
> failed (edit registration properties to change the login name)". I
> believe it's got something to do with the change in the host name. Is
> this why? If so, how can I fix it? I need to be able to restore
> Master on this server. I've tried all logins, including domain admin,
> Sa and so on to connect.
> (c) We have a computer connected to a card reader machine that makes
> an entry into a table when a card is flashed in front of it. This
> software was written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a
> Windows 2003 Server. Sometimes, we get the error
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation. "
> After reading much about it, I changed the connection string to
> include a OLE DB Services = -2. This does not help either! Does
> anybody have a workable solution.
> Thanks for your time.
> Vince
A)
You can use the sp_helprotect system proc to report on all granted
access. I think the following will work (not tested):
Exec sp_helprotect NULL, NULL, NULL, NULL
David Gugick
Imceda Software
www.imceda.com
|||Vince wrote:
> Hey All,
> (b) I backed up our Master Database on the SQL Server. The host name
> is SQLSERVERA. Now, we have a new computer with the host name
> SQLSERVERB. When I restored the Master on this new server, I cannot
> open the SQL Server connection in Enterprise manager! It says "login
> failed (edit registration properties to change the login name)". I
> believe it's got something to do with the change in the host name. Is
> this why? If so, how can I fix it? I need to be able to restore
> Master on this server. I've tried all logins, including domain admin,
> Sa and so on to connect.
>
Change the name of the server back to SQLSERVERA. From QA, use
sp_addserver to add SQLSERVERB, and then change the server name back to
SQLSERVERB. I think that should do it.
David Gugick
Imceda Software
www.imceda.com
|||David,
Thank you.
A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I wanted.
B) I think that should do it too. I'll try it
Thanks, again. Any idea on C?
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:elzDDAZ5EHA.1392@.tk2msftngp13.phx.gbl...
> Vince wrote:
> Change the name of the server back to SQLSERVERA. From QA, use
> sp_addserver to add SQLSERVERB, and then change the server name back to
> SQLSERVERB. I think that should do it.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Vince wrote:
> David,
> Thank you.
> A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I
> wanted. B) I think that should do it too. I'll try it
> Thanks, again. Any idea on C?
>
Item C sounds like an application issue. How does the application
normally connect to the server? ADO, ODBC, RDO? You might try installing
SQL Server SP3a Service Pack on the client PC to update the client
tools. Or refreshing the ADO installation if MDAC is used. If ODBC, make
sure the ODBC DSN is set up correctly.
Some articles to look at:
http://support.microsoft.com/default...;en-us;Q229564
http://support.microsoft.com/default...b;en-us;827452
David Gugick
Imceda Software
www.imceda.com
|||Thanks for your reply. I use OLEDB, ADO to connect to the SQL Server. I
already looked into the support pages / updated MDAC / Added the OLE DB
Services= -2 but I still get this error at random intervals. Sometimes after
5 days, sometimes the same day. It happens so randomly that I cannot
establish any pattern! The last I got the error was about 5 days back. The
frequency is around 2 or 3 times a week. Low, but annoying.
Vince
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23eQvnbf5EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Vince wrote:
> Item C sounds like an application issue. How does the application
> normally connect to the server? ADO, ODBC, RDO? You might try installing
> SQL Server SP3a Service Pack on the client PC to update the client
> tools. Or refreshing the ADO installation if MDAC is used. If ODBC, make
> sure the ODBC DSN is set up correctly.
> Some articles to look at:
> http://support.microsoft.com/default...;en-us;Q229564
> http://support.microsoft.com/default...b;en-us;827452
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||b) You have to make sure that the SQL Server service accounts from SERVERB
have access to SERVERA before you backup the master on SERVERA. Otherwise,
when you restore to SERVERB, SQL Server will gain access using base system
access but nothing else will function.
c) Make sure you update the MDAC on the client machine. If you've installed
the NETLIB system files, you will need to make sure they have been upgrades
to SP3a as well.
Sincerely,
Anthony Thomas
"Vince" <nmvkPLEASERMVTHIS@.vsnl.net> wrote in message
news:%23Y5IIdX5EHA.3644@.tk2msftngp13.phx.gbl...
Hey All,
I have three questions:
(a) A new guy at work needs a list of type of permissions granted to users.
I really don't want to type all of it. Is there some software that exports
the permissions in a readable format from the SQL Server?
(b) I backed up our Master Database on the SQL Server. The host name is
SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB. When
I restored the Master on this new server, I cannot open the SQL Server
connection in Enterprise manager! It says "login failed (edit registration
properties to change the login name)". I believe it's got something to do
with the change in the host name. Is this why? If so, how can I fix it? I
need to be able to restore Master on this server. I've tried all logins,
including domain admin, Sa and so on to connect.
(c) We have a computer connected to a card reader machine that makes an
entry into a table when a card is flashed in front of it. This software was
written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
Server. Sometimes, we get the error
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation. "
After reading much about it, I changed the connection string to include a
OLE DB Services = -2. This does not help either! Does anybody have a
workable solution.
Thanks for your time.
Vince
|||Thanks Anthony. I already updated MDAC (some 2 days back) and so far the
problem has not appeared. But, I'll know for sure at the end of the week.
Thanks, again.
Vince
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
news:uXdEJel5EHA.1300@.TK2MSFTNGP14.phx.gbl...
> b) You have to make sure that the SQL Server service accounts from SERVERB
> have access to SERVERA before you backup the master on SERVERA.
Otherwise,
> when you restore to SERVERB, SQL Server will gain access using base system
> access but nothing else will function.
> c) Make sure you update the MDAC on the client machine. If you've
installed
> the NETLIB system files, you will need to make sure they have been
upgrades
> to SP3a as well.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Vince" <nmvkPLEASERMVTHIS@.vsnl.net> wrote in message
> news:%23Y5IIdX5EHA.3644@.tk2msftngp13.phx.gbl...
> Hey All,
> I have three questions:
> (a) A new guy at work needs a list of type of permissions granted to
users.
> I really don't want to type all of it. Is there some software that exports
> the permissions in a readable format from the SQL Server?
> (b) I backed up our Master Database on the SQL Server. The host name is
> SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB.
When
> I restored the Master on this new server, I cannot open the SQL Server
> connection in Enterprise manager! It says "login failed (edit registration
> properties to change the login name)". I believe it's got something to do
> with the change in the host name. Is this why? If so, how can I fix it? I
> need to be able to restore Master on this server. I've tried all logins,
> including domain admin, Sa and so on to connect.
> (c) We have a computer connected to a card reader machine that makes an
> entry into a table when a card is flashed in front of it. This software
was
> written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
> Server. Sometimes, we get the error
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation. "
> After reading much about it, I changed the connection string to include a
> OLE DB Services = -2. This does not help either! Does anybody have a
> workable solution.
> Thanks for your time.
> Vince
>
Showing posts with label guy. Show all posts
Showing posts with label guy. Show all posts
Monday, March 12, 2012
Permissions and Connection
Hey All,
I have three questions:
(a) A new guy at work needs a list of type of permissions granted to users.
I really don't want to type all of it. Is there some software that exports
the permissions in a readable format from the SQL Server?
(b) I backed up our Master Database on the SQL Server. The host name is
SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB. When
I restored the Master on this new server, I cannot open the SQL Server
connection in Enterprise manager! It says "login failed (edit registration
properties to change the login name)". I believe it's got something to do
with the change in the host name. Is this why? If so, how can I fix it? I
need to be able to restore Master on this server. I've tried all logins,
including domain admin, Sa and so on to connect.
(c) We have a computer connected to a card reader machine that makes an
entry into a table when a card is flashed in front of it. This software was
written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
Server. Sometimes, we get the error
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation. "
After reading much about it, I changed the connection string to include a
OLE DB Services = -2. This does not help either! Does anybody have a
workable solution.
Thanks for your time.
VinceVince wrote:
> Hey All,
> I have three questions:
> (a) A new guy at work needs a list of type of permissions granted to
> users. I really don't want to type all of it. Is there some software
> that exports the permissions in a readable format from the SQL Server?
> (b) I backed up our Master Database on the SQL Server. The host name
> is SQLSERVERA. Now, we have a new computer with the host name
> SQLSERVERB. When I restored the Master on this new server, I cannot
> open the SQL Server connection in Enterprise manager! It says "login
> failed (edit registration properties to change the login name)". I
> believe it's got something to do with the change in the host name. Is
> this why? If so, how can I fix it? I need to be able to restore
> Master on this server. I've tried all logins, including domain admin,
> Sa and so on to connect.
> (c) We have a computer connected to a card reader machine that makes
> an entry into a table when a card is flashed in front of it. This
> software was written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a
> Windows 2003 Server. Sometimes, we get the error
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation. "
> After reading much about it, I changed the connection string to
> include a OLE DB Services = -2. This does not help either! Does
> anybody have a workable solution.
> Thanks for your time.
> Vince
A)
You can use the sp_helprotect system proc to report on all granted
access. I think the following will work (not tested):
Exec sp_helprotect NULL, NULL, NULL, NULL
David Gugick
Imceda Software
www.imceda.com|||Vince wrote:
> Hey All,
> (b) I backed up our Master Database on the SQL Server. The host name
> is SQLSERVERA. Now, we have a new computer with the host name
> SQLSERVERB. When I restored the Master on this new server, I cannot
> open the SQL Server connection in Enterprise manager! It says "login
> failed (edit registration properties to change the login name)". I
> believe it's got something to do with the change in the host name. Is
> this why? If so, how can I fix it? I need to be able to restore
> Master on this server. I've tried all logins, including domain admin,
> Sa and so on to connect.
>
Change the name of the server back to SQLSERVERA. From QA, use
sp_addserver to add SQLSERVERB, and then change the server name back to
SQLSERVERB. I think that should do it.
--
David Gugick
Imceda Software
www.imceda.com|||David,
Thank you.
A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I wanted.
B) I think that should do it too. I'll try it
Thanks, again. Any idea on C?
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:elzDDAZ5EHA.1392@.tk2msftngp13.phx.gbl...
> Vince wrote:
> > Hey All,
> >
> > (b) I backed up our Master Database on the SQL Server. The host name
> > is SQLSERVERA. Now, we have a new computer with the host name
> > SQLSERVERB. When I restored the Master on this new server, I cannot
> > open the SQL Server connection in Enterprise manager! It says "login
> > failed (edit registration properties to change the login name)". I
> > believe it's got something to do with the change in the host name. Is
> > this why? If so, how can I fix it? I need to be able to restore
> > Master on this server. I've tried all logins, including domain admin,
> > Sa and so on to connect.
> >
> Change the name of the server back to SQLSERVERA. From QA, use
> sp_addserver to add SQLSERVERB, and then change the server name back to
> SQLSERVERB. I think that should do it.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Vince wrote:
> David,
> Thank you.
> A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I
> wanted. B) I think that should do it too. I'll try it
> Thanks, again. Any idea on C?
>
Item C sounds like an application issue. How does the application
normally connect to the server? ADO, ODBC, RDO? You might try installing
SQL Server SP3a Service Pack on the client PC to update the client
tools. Or refreshing the ADO installation if MDAC is used. If ODBC, make
sure the ODBC DSN is set up correctly.
Some articles to look at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
David Gugick
Imceda Software
www.imceda.com|||Thanks for your reply. I use OLEDB, ADO to connect to the SQL Server. I
already looked into the support pages / updated MDAC / Added the OLE DB
Services= -2 but I still get this error at random intervals. Sometimes after
5 days, sometimes the same day. It happens so randomly that I cannot
establish any pattern! The last I got the error was about 5 days back. The
frequency is around 2 or 3 times a week. Low, but annoying.
Vince
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23eQvnbf5EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Vince wrote:
> > David,
> >
> > Thank you.
> > A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I
> > wanted. B) I think that should do it too. I'll try it
> >
> > Thanks, again. Any idea on C?
> >
> Item C sounds like an application issue. How does the application
> normally connect to the server? ADO, ODBC, RDO? You might try installing
> SQL Server SP3a Service Pack on the client PC to update the client
> tools. Or refreshing the ADO installation if MDAC is used. If ODBC, make
> sure the ODBC DSN is set up correctly.
> Some articles to look at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564
> http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||b) You have to make sure that the SQL Server service accounts from SERVERB
have access to SERVERA before you backup the master on SERVERA. Otherwise,
when you restore to SERVERB, SQL Server will gain access using base system
access but nothing else will function.
c) Make sure you update the MDAC on the client machine. If you've installed
the NETLIB system files, you will need to make sure they have been upgrades
to SP3a as well.
Sincerely,
Anthony Thomas
"Vince" <nmvkPLEASERMVTHIS@.vsnl.net> wrote in message
news:%23Y5IIdX5EHA.3644@.tk2msftngp13.phx.gbl...
Hey All,
I have three questions:
(a) A new guy at work needs a list of type of permissions granted to users.
I really don't want to type all of it. Is there some software that exports
the permissions in a readable format from the SQL Server?
(b) I backed up our Master Database on the SQL Server. The host name is
SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB. When
I restored the Master on this new server, I cannot open the SQL Server
connection in Enterprise manager! It says "login failed (edit registration
properties to change the login name)". I believe it's got something to do
with the change in the host name. Is this why? If so, how can I fix it? I
need to be able to restore Master on this server. I've tried all logins,
including domain admin, Sa and so on to connect.
(c) We have a computer connected to a card reader machine that makes an
entry into a table when a card is flashed in front of it. This software was
written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
Server. Sometimes, we get the error
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation. "
After reading much about it, I changed the connection string to include a
OLE DB Services = -2. This does not help either! Does anybody have a
workable solution.
Thanks for your time.
Vince|||Thanks Anthony. I already updated MDAC (some 2 days back) and so far the
problem has not appeared. But, I'll know for sure at the end of the week.
Thanks, again.
Vince
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
news:uXdEJel5EHA.1300@.TK2MSFTNGP14.phx.gbl...
> b) You have to make sure that the SQL Server service accounts from SERVERB
> have access to SERVERA before you backup the master on SERVERA.
Otherwise,
> when you restore to SERVERB, SQL Server will gain access using base system
> access but nothing else will function.
> c) Make sure you update the MDAC on the client machine. If you've
installed
> the NETLIB system files, you will need to make sure they have been
upgrades
> to SP3a as well.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Vince" <nmvkPLEASERMVTHIS@.vsnl.net> wrote in message
> news:%23Y5IIdX5EHA.3644@.tk2msftngp13.phx.gbl...
> Hey All,
> I have three questions:
> (a) A new guy at work needs a list of type of permissions granted to
users.
> I really don't want to type all of it. Is there some software that exports
> the permissions in a readable format from the SQL Server?
> (b) I backed up our Master Database on the SQL Server. The host name is
> SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB.
When
> I restored the Master on this new server, I cannot open the SQL Server
> connection in Enterprise manager! It says "login failed (edit registration
> properties to change the login name)". I believe it's got something to do
> with the change in the host name. Is this why? If so, how can I fix it? I
> need to be able to restore Master on this server. I've tried all logins,
> including domain admin, Sa and so on to connect.
> (c) We have a computer connected to a card reader machine that makes an
> entry into a table when a card is flashed in front of it. This software
was
> written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
> Server. Sometimes, we get the error
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation. "
> After reading much about it, I changed the connection string to include a
> OLE DB Services = -2. This does not help either! Does anybody have a
> workable solution.
> Thanks for your time.
> Vince
>
I have three questions:
(a) A new guy at work needs a list of type of permissions granted to users.
I really don't want to type all of it. Is there some software that exports
the permissions in a readable format from the SQL Server?
(b) I backed up our Master Database on the SQL Server. The host name is
SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB. When
I restored the Master on this new server, I cannot open the SQL Server
connection in Enterprise manager! It says "login failed (edit registration
properties to change the login name)". I believe it's got something to do
with the change in the host name. Is this why? If so, how can I fix it? I
need to be able to restore Master on this server. I've tried all logins,
including domain admin, Sa and so on to connect.
(c) We have a computer connected to a card reader machine that makes an
entry into a table when a card is flashed in front of it. This software was
written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
Server. Sometimes, we get the error
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation. "
After reading much about it, I changed the connection string to include a
OLE DB Services = -2. This does not help either! Does anybody have a
workable solution.
Thanks for your time.
VinceVince wrote:
> Hey All,
> I have three questions:
> (a) A new guy at work needs a list of type of permissions granted to
> users. I really don't want to type all of it. Is there some software
> that exports the permissions in a readable format from the SQL Server?
> (b) I backed up our Master Database on the SQL Server. The host name
> is SQLSERVERA. Now, we have a new computer with the host name
> SQLSERVERB. When I restored the Master on this new server, I cannot
> open the SQL Server connection in Enterprise manager! It says "login
> failed (edit registration properties to change the login name)". I
> believe it's got something to do with the change in the host name. Is
> this why? If so, how can I fix it? I need to be able to restore
> Master on this server. I've tried all logins, including domain admin,
> Sa and so on to connect.
> (c) We have a computer connected to a card reader machine that makes
> an entry into a table when a card is flashed in front of it. This
> software was written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a
> Windows 2003 Server. Sometimes, we get the error
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation. "
> After reading much about it, I changed the connection string to
> include a OLE DB Services = -2. This does not help either! Does
> anybody have a workable solution.
> Thanks for your time.
> Vince
A)
You can use the sp_helprotect system proc to report on all granted
access. I think the following will work (not tested):
Exec sp_helprotect NULL, NULL, NULL, NULL
David Gugick
Imceda Software
www.imceda.com|||Vince wrote:
> Hey All,
> (b) I backed up our Master Database on the SQL Server. The host name
> is SQLSERVERA. Now, we have a new computer with the host name
> SQLSERVERB. When I restored the Master on this new server, I cannot
> open the SQL Server connection in Enterprise manager! It says "login
> failed (edit registration properties to change the login name)". I
> believe it's got something to do with the change in the host name. Is
> this why? If so, how can I fix it? I need to be able to restore
> Master on this server. I've tried all logins, including domain admin,
> Sa and so on to connect.
>
Change the name of the server back to SQLSERVERA. From QA, use
sp_addserver to add SQLSERVERB, and then change the server name back to
SQLSERVERB. I think that should do it.
--
David Gugick
Imceda Software
www.imceda.com|||David,
Thank you.
A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I wanted.
B) I think that should do it too. I'll try it
Thanks, again. Any idea on C?
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:elzDDAZ5EHA.1392@.tk2msftngp13.phx.gbl...
> Vince wrote:
> > Hey All,
> >
> > (b) I backed up our Master Database on the SQL Server. The host name
> > is SQLSERVERA. Now, we have a new computer with the host name
> > SQLSERVERB. When I restored the Master on this new server, I cannot
> > open the SQL Server connection in Enterprise manager! It says "login
> > failed (edit registration properties to change the login name)". I
> > believe it's got something to do with the change in the host name. Is
> > this why? If so, how can I fix it? I need to be able to restore
> > Master on this server. I've tried all logins, including domain admin,
> > Sa and so on to connect.
> >
> Change the name of the server back to SQLSERVERA. From QA, use
> sp_addserver to add SQLSERVERB, and then change the server name back to
> SQLSERVERB. I think that should do it.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Vince wrote:
> David,
> Thank you.
> A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I
> wanted. B) I think that should do it too. I'll try it
> Thanks, again. Any idea on C?
>
Item C sounds like an application issue. How does the application
normally connect to the server? ADO, ODBC, RDO? You might try installing
SQL Server SP3a Service Pack on the client PC to update the client
tools. Or refreshing the ADO installation if MDAC is used. If ODBC, make
sure the ODBC DSN is set up correctly.
Some articles to look at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
David Gugick
Imceda Software
www.imceda.com|||Thanks for your reply. I use OLEDB, ADO to connect to the SQL Server. I
already looked into the support pages / updated MDAC / Added the OLE DB
Services= -2 but I still get this error at random intervals. Sometimes after
5 days, sometimes the same day. It happens so randomly that I cannot
establish any pattern! The last I got the error was about 5 days back. The
frequency is around 2 or 3 times a week. Low, but annoying.
Vince
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23eQvnbf5EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Vince wrote:
> > David,
> >
> > Thank you.
> > A) The command EXEC sp_helprotect NULL, NULL, NULL,'O' does what I
> > wanted. B) I think that should do it too. I'll try it
> >
> > Thanks, again. Any idea on C?
> >
> Item C sounds like an application issue. How does the application
> normally connect to the server? ADO, ODBC, RDO? You might try installing
> SQL Server SP3a Service Pack on the client PC to update the client
> tools. Or refreshing the ADO installation if MDAC is used. If ODBC, make
> sure the ODBC DSN is set up correctly.
> Some articles to look at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564
> http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||b) You have to make sure that the SQL Server service accounts from SERVERB
have access to SERVERA before you backup the master on SERVERA. Otherwise,
when you restore to SERVERB, SQL Server will gain access using base system
access but nothing else will function.
c) Make sure you update the MDAC on the client machine. If you've installed
the NETLIB system files, you will need to make sure they have been upgrades
to SP3a as well.
Sincerely,
Anthony Thomas
"Vince" <nmvkPLEASERMVTHIS@.vsnl.net> wrote in message
news:%23Y5IIdX5EHA.3644@.tk2msftngp13.phx.gbl...
Hey All,
I have three questions:
(a) A new guy at work needs a list of type of permissions granted to users.
I really don't want to type all of it. Is there some software that exports
the permissions in a readable format from the SQL Server?
(b) I backed up our Master Database on the SQL Server. The host name is
SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB. When
I restored the Master on this new server, I cannot open the SQL Server
connection in Enterprise manager! It says "login failed (edit registration
properties to change the login name)". I believe it's got something to do
with the change in the host name. Is this why? If so, how can I fix it? I
need to be able to restore Master on this server. I've tried all logins,
including domain admin, Sa and so on to connect.
(c) We have a computer connected to a card reader machine that makes an
entry into a table when a card is flashed in front of it. This software was
written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
Server. Sometimes, we get the error
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation. "
After reading much about it, I changed the connection string to include a
OLE DB Services = -2. This does not help either! Does anybody have a
workable solution.
Thanks for your time.
Vince|||Thanks Anthony. I already updated MDAC (some 2 days back) and so far the
problem has not appeared. But, I'll know for sure at the end of the week.
Thanks, again.
Vince
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
news:uXdEJel5EHA.1300@.TK2MSFTNGP14.phx.gbl...
> b) You have to make sure that the SQL Server service accounts from SERVERB
> have access to SERVERA before you backup the master on SERVERA.
Otherwise,
> when you restore to SERVERB, SQL Server will gain access using base system
> access but nothing else will function.
> c) Make sure you update the MDAC on the client machine. If you've
installed
> the NETLIB system files, you will need to make sure they have been
upgrades
> to SP3a as well.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Vince" <nmvkPLEASERMVTHIS@.vsnl.net> wrote in message
> news:%23Y5IIdX5EHA.3644@.tk2msftngp13.phx.gbl...
> Hey All,
> I have three questions:
> (a) A new guy at work needs a list of type of permissions granted to
users.
> I really don't want to type all of it. Is there some software that exports
> the permissions in a readable format from the SQL Server?
> (b) I backed up our Master Database on the SQL Server. The host name is
> SQLSERVERA. Now, we have a new computer with the host name SQLSERVERB.
When
> I restored the Master on this new server, I cannot open the SQL Server
> connection in Enterprise manager! It says "login failed (edit registration
> properties to change the login name)". I believe it's got something to do
> with the change in the host name. Is this why? If so, how can I fix it? I
> need to be able to restore Master on this server. I've tried all logins,
> including domain admin, Sa and so on to connect.
> (c) We have a computer connected to a card reader machine that makes an
> entry into a table when a card is flashed in front of it. This software
was
> written in VB 6. Our SQL Server is a SQL 2000 SP 3A on a Windows 2003
> Server. Sometimes, we get the error
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation. "
> After reading much about it, I changed the connection string to include a
> OLE DB Services = -2. This does not help either! Does anybody have a
> workable solution.
> Thanks for your time.
> Vince
>
Subscribe to:
Posts (Atom)