Persist ConnectionString

Hello All,

I have changed connection string property of connectionmanger at runtime and saved package.But my new connectionstring is not persisting, i am getting my old connection string after reload package .

ConnectionManager cm = package.Connections[test.ConnectionManagerID];

cm.ConnectionString = @."C:\Test.csv";

app.SaveToDtsServer(package, null,

@."File System\Dupaco Load Next Best.dtsx", "CIRCLE");

How can I save new connection string?.

Please help me.

Thanks

Subin

The ProtectionLevel property of the ConnectionManager will change what and if sensitive information is saved.

Personally I do not like saving sensitive information in a package, I much prefer using configurations. This allows you to keep such information externally, and just by changing the configuartion information between environments you can easily manage this. This mechanism is obviously great for when moving packages between test and production environments for example, but it scales right down to the developer's desktop, so you use the same mechanism throughout.

Perpetual connection

Does anyone know the purpose of sp_trace_getdata and if it is normal for it
to run all the time. We have 2 production servers (mostly the same SQL
settings) so I am not sure why this is constantly running on one server and
not the other?
thanks
Meenal
sp_trace_getdata shows up when you are tracing SQL server activity, using
profiler or other means. You should see a number next to this. and that is
the ID of the trace. You can run the following sql to get more information
on that trace:
select * from ::fn_trace_getinfo(id)
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:%232tCyirOFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Does anyone know the purpose of sp_trace_getdata and if it is normal for
> it
> to run all the time. We have 2 production servers (mostly the same SQL
> settings) so I am not sure why this is constantly running on one server
> and
> not the other?
> thanks
> Meenal
>
sql

Perpetual connection

Does anyone know the purpose of sp_trace_getdata and if it is normal for it
to run all the time. We have 2 production servers (mostly the same SQL
settings) so I am not sure why this is constantly running on one server and
not the other?
thanks
Meenalsp_trace_getdata shows up when you are tracing SQL server activity, using
profiler or other means. You should see a number next to this. and that is
the ID of the trace. You can run the following sql to get more information
on that trace:
select * from ::fn_trace_getinfo(id)
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:%232tCyirOFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Does anyone know the purpose of sp_trace_getdata and if it is normal for
> it
> to run all the time. We have 2 production servers (mostly the same SQL
> settings) so I am not sure why this is constantly running on one server
> and
> not the other?
> thanks
> Meenal
>

Perpetual connection

Does anyone know the purpose of sp_trace_getdata and if it is normal for it
to run all the time. We have 2 production servers (mostly the same SQL
settings) so I am not sure why this is constantly running on one server and
not the other?
thanks
Meenalsp_trace_getdata shows up when you are tracing SQL server activity, using
profiler or other means. You should see a number next to this. and that is
the ID of the trace. You can run the following sql to get more information
on that trace:
select * from ::fn_trace_getinfo(id)
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:%232tCyirOFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Does anyone know the purpose of sp_trace_getdata and if it is normal for
> it
> to run all the time. We have 2 production servers (mostly the same SQL
> settings) so I am not sure why this is constantly running on one server
> and
> not the other?
> thanks
> Meenal
>

Permissions when using trusted connection

I want my users to use trusted connection when logging in to the SQL Server,
and that goes successful, but the strange thing is that the SQL Server
seemes to think that the logged in user is "sa" which is not so good, cause
then the user has all the pemissons. I want to set the permissions manually
for each "trusted connection"-user. What am I doing wrong. Probably an easy
question.When you login with a trusted connection (no userid/password in connection
string), you are logged in as that account rather than the 'sa' SQL Server
account. If the Windows account has sa-like permissions, then a likely
cause is that the user is a member of the SQL Server sysadmin server role.
Members of the Windows local Administrators group are sysadmin role members
by default so perhaps the account is an admin on the SQL Server box.
A best practice in SQL Server security admin is to grant permissions to
roles rather than individual users. This simplifies administration because
you can control access via role membership.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Uffe" <uffe.waldero@.home.se> wrote in message
news:ubEysOg0DHA.1684@.TK2MSFTNGP12.phx.gbl...
> I want my users to use trusted connection when logging in to the SQL
Server,
> and that goes successful, but the strange thing is that the SQL Server
> seemes to think that the logged in user is "sa" which is not so good,
cause
> then the user has all the pemissons. I want to set the permissions
manually
> for each "trusted connection"-user. What am I doing wrong. Probably an
easy
> question.
>|||I suspect the NT logins are members of a group for which you have given
sysadmin privileges.
Check all of your sql roles and remember everyone is a member of the public
role.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Uffe" <uffe.waldero@.home.se> wrote in message
news:ubEysOg0DHA.1684@.TK2MSFTNGP12.phx.gbl...
> I want my users to use trusted connection when logging in to the SQL
Server,
> and that goes successful, but the strange thing is that the SQL Server
> seemes to think that the logged in user is "sa" which is not so good,
cause
> then the user has all the pemissons. I want to set the permissions
manually
> for each "trusted connection"-user. What am I doing wrong. Probably an
easy
> question.
>|||Why don't you make these users members of the db_datawriter fixed database
role? You can find more info in books online but here's an example:
EXEC sp_addrolemember 'db_datawriter', 'username'
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Eugene" <eliu@.ctisinc.com> wrote in message
news:30D10394-6085-4C6B-A268-9E3BFA75833A@.microsoft.com...
> HI,
> I am having a little different issue. When my windows users login into sql
server with trustes connection, they can select the data but no update and
insert. It said permission denied. But I have put them into DBO group or
role and have all permission on database. What went wrong ? Please help.
Many thanks.sql

Permissions when using trusted connection

HI,
I am having a little different issue. When my windows users login into sql s
erver with trustes connection, they can select the data but no update and in
sert. It said permission denied. But I have put them into DBO group or role
and have all permission on
database. What went wrong ? Please help. Many thanks.Why don't you make these users members of the db_datawriter fixed database
role? You can find more info in books online but here's an example:
EXEC sp_addrolemember 'db_datawriter', 'username'
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Eugene" <eliu@.ctisinc.com> wrote in message
news:30D10394-6085-4C6B-A268-9E3BFA75833A@.microsoft.com...

quote:

---

> HI,
> I am having a little different issue. When my windows users login into sql

---

server with trustes connection, they can select the data but no update and
insert. It said permission denied. But I have put them into DBO group or
role and have all permission on database. What went wrong ? Please help.
Many thanks.

permissions sql express and remote connection problems TIA

posted to the forums a few weeks ago, followed the suggestion but the problem has not been squared, the link for my original post is at the bottom of this message.

have tried most of the suggestions in the forums, again see the link for details on steps i have tried, kept poking around and came up with a few more possibilities for the problem,

the error message is the one that says sql server express remote connnections are not enabled by default during the install of sql express,

backed up a little and it seems i can not even connect to the local machine, i ran the sqlcmd -s -e \sqlexpress and the login timesouts and says that sql express refused the connection, have shared memory protocal and tcp/ip running also tried it with named pipes,

so that left me wonderin if maybe permission for sql express need to be adjusted, brought up SQL server Studio Mangement Express console and went to the only express instance on the local machine, brought up properties for \sqlexpress and went to the permission section and noticed the following:

for the BuiltIn\administrator and builtIn\User account the only permission that is checked off is the "Conect SQL" which has only the Grant checkbox checked, also the grantor is sa, btw what does the checkbox With Grant do? this was the same for the both accounts,

for the public account the only permission that is enabled is the View any database,

are there other permission which need to be granted or "with granted", also i assume i should not be using the sa account or should i?

other things going on include include Visual Studio 2005, i am able to get to the database thru Server Explorer, and can bring up the tables and see them, sometimes thos their is a red x on the mdf, but when i click it brings them up.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=217258&SiteID=1

Are you using a named instance? What instance names do you have in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL?

"sqlcmd -E -S \sqlexpress" will work only if the main instance is called sqlexpress, if it is called differently, then you have to use that name.

Have you ever been able to connect locally with sqlcmd? Let's figure out first what's wrong with the local connection, and then we can investigate the remote issues.

Thanks
Laurentiu

|||

Thanks Lauretiu, check the registry and it looks alright, the keys are below:

name SQLexpress

type reg_sz

data mssql.1

not sure if i have ever connected locally, have never been able to get either the sqlcmd -e -s \sqlexpress to work, or the aspnet_regsql wixard to work, (is ther anothe way to test the local connection?) for the sqlcmd i get a get a message like this,

HResult 0x274D, Level 16, State 1
TCP Provider: No connection could be made because the target machine actively refused it

sqlcmd: Error Microsoft sql native client :an error has occurred while establishing a connection th the server. When conecting th SQL server 2005, this failure may be caused by the fact that unde rth edefault settings sql server does not allow remote connecitons. and the a login timeout expired.

the server has a different ip address than the laptop itself.

the aspnet_regsql error message is very similar,

|||

Here's a link that discusses some connection failures and mentions the 0x274D error:

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

According to Peter, one of the reasons for this message could be that TCP is not enabled. Could you check that the TCP protocol is enabled? You can use the Configuration Manager and look under SQL Server 2005 Network Configuration->Protocols for SQLEXPRESS. I'll see if I can find anything else about this error.

Thanks
Laurentiu

|||

This may be just a typo in the post but the correct syntax for the sqlcmd command run on the same machine where SQL Express runs is:

sqlcmd -E -S .\sqlexpress

Note:

- the capital -E and -S (the case matters in the option selection)

- the dot before the \ character

In your original post you mentioned that the SQL Express lists port 1232 under IPAll. If you get the same error ("TCP Provider: No connection could be made because the target machine actively refused it") after running the above sqlcmd statement, you can troubleshoot it by running:

telnet <machineName> 1232

- replace <machineName> with the actual name of your machine.

- if it fails with an error similar to "Could not open connection to the host" it means SQL Express is not configured for TCP, and may need to be restarted.

- if it gives you a blank screen it means it connected, and you should be able to connect through

sqlcmd -E -S tcp:.\sqlexpress,1232

|||

Hey Peter thank

it was the capital -S that was causing the problem, a weeks delay over a cap, should know better by now, thanks again, take care

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.
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
>

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
>