Hidden User?

Did a remote backup of a database used to run a live website.
Restored the database to my local MSDE installation.
Now cannot access the local database using the user login FRED, which is the
same as the website, as I use it for local testing. Get error message:
cannot open user default database login failed.
Cannot see FRED the user anywhere, yet if I look under Roles, FRED is listed
as a db_owner.
If try and add FRED, get error saying User or Role already exists on this
database.
How can I reactivate FRED on my local server?
hi Kevin,
"Kevin" <kevgrim@.tesco.net> ha scritto nel messaggio
news:%23BNg60wdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Did a remote backup of a database used to run a live website.
> Restored the database to my local MSDE installation.
> Now cannot access the local database using the user login FRED, which is
the
> same as the website, as I use it for local testing. Get error message:
> cannot open user default database login failed.
> Cannot see FRED the user anywhere, yet if I look under Roles, FRED is
listed
> as a db_owner.
> If try and add FRED, get error saying User or Role already exists on this
> database.
> How can I reactivate FRED on my local server?
>
this problem is known as "orphaned users"... you can have a look at a
perfect article by Neil Boyl abot the matter at
http://www.sqlservercentral.com/colu...okenlogins.asp
the system stored procedure sp_chang_users_logins use is explained for
solving your trouble
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Hi Everybody, Sql Server 2005 SE installation problem

I faced the following problem while installing Sql Server 2005 SE

"Error 193 Installing .NET Framework 2.0" while installing Sql Server 2005

Please help me to proceed further

i have the same error. did you work around it?|||I am also having this problem. Has anyone else encountered this particular error?|||

Are there any log files created under:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG?

If so, you can start by looking at Summary.txt. It should give you some indication of which component failed. Then you should be able to delve into the specific log file of the failed component. If you'd like, zip up the LOG directory and send it to me and I'll have a look (jeff.papiez@.microsoft.com)

|||You can also try installing .NET Frameworks 2.0 directly by calling \Redist\2.0\dotnetfx.exe. This will give you the full UI installation of .NET Frameworks 2.0 which may have some better error messages.|||

Hi

Im having the same problem.

What to do ?

Thanks

|||

Hi

This might sound stupid but i copied the "SQL Server x86" folder from the DVD onto my local hard drive and ran the "\SQL Server x86\Servers\setup.exe" from the hard drive copy to install the server components. Lo and behold everything worked fine.

---

- faizelk

sql

Hi Everybody, Sql Server 2005 SE installation problem

I faced the following problem while installing Sql Server 2005 SE

"Error 193 Installing .NET Framework 2.0" while installing Sql Server 2005

Please help me to proceed further

i have the same error. did you work around it?|||I am also having this problem. Has anyone else encountered this particular error?|||

Are there any log files created under:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG?

If so, you can start by looking at Summary.txt. It should give you some indication of which component failed. Then you should be able to delve into the specific log file of the failed component. If you'd like, zip up the LOG directory and send it to me and I'll have a look (jeff.papiez@.microsoft.com)

|||You can also try installing .NET Frameworks 2.0 directly by calling \Redist\2.0\dotnetfx.exe. This will give you the full UI installation of .NET Frameworks 2.0 which may have some better error messages.|||

Hi

Im having the same problem.

What to do ?

Thanks

|||

Hi

This might sound stupid but i copied the "SQL Server x86" folder from the DVD onto my local hard drive and ran the "\SQL Server x86\Servers\setup.exe" from the hard drive copy to install the server components. Lo and behold everything worked fine.

---

- faizelk

Hi Everybody, Sql Server 2005 SE installation problem

I faced the following problem while installing Sql Server 2005 SE

"Error 193 Installing .NET Framework 2.0" while installing Sql Server 2005

Please help me to proceed further

i have the same error. did you work around it?|||I am also having this problem. Has anyone else encountered this particular error?|||

Are there any log files created under:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG?

If so, you can start by looking at Summary.txt. It should give you some indication of which component failed. Then you should be able to delve into the specific log file of the failed component. If you'd like, zip up the LOG directory and send it to me and I'll have a look (jeff.papiez@.microsoft.com)

|||You can also try installing .NET Frameworks 2.0 directly by calling \Redist\2.0\dotnetfx.exe. This will give you the full UI installation of .NET Frameworks 2.0 which may have some better error messages.|||

Hi

Im having the same problem.

What to do ?

Thanks

|||

Hi

This might sound stupid but i copied the "SQL Server x86" folder from the DVD onto my local hard drive and ran the "\SQL Server x86\Servers\setup.exe" from the hard drive copy to install the server components. Lo and behold everything worked fine.

---

- faizelk

Hi

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitiveExample: If have a Customers table and a record has last_name = "Bob", then:
Select * from customers where last_name = 'bob'
will return that record if it's case-insensitive, otherwise not.|||

Quote:

Originally Posted by sravani1227

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitive

Hi,
You don't need to install MSSQL server two times intead you have to change
default collation of your databse .
you will use COLLATE SQL_Latin1_General_CP1_CS_AS to make your search case sensitive.

HELP: SP4 Version?

I am convinced we do not have SQL 2000 SP4 installed but the console says I
do. After a few failed installation of SP4 I cannot imagine it is truly
installed.
It says: 8.00.2039 (SP4)
Do I REALLY have SP4?
@.@.version of 8.00.2039 seems correct.
"Whispering Leaf" wrote:

> I am convinced we do not have SQL 2000 SP4 installed but the console says
I
> do. After a few failed installation of SP4 I cannot imagine it is truly
> installed.
> It says: 8.00.2039 (SP4)
> Do I REALLY have SP4?
>
>

HELP: SP4 Version?

I am convinced we do not have SQL 2000 SP4 installed but the console says I
do. After a few failed installation of SP4 I cannot imagine it is truly
installed.
It says: 8.00.2039 (SP4)
Do I REALLY have SP4?
:)@.@.version of 8.00.2039 seems correct.
"Whispering Leaf" wrote:
> I am convinced we do not have SQL 2000 SP4 installed but the console says I
> do. After a few failed installation of SP4 I cannot imagine it is truly
> installed.
> It says: 8.00.2039 (SP4)
> Do I REALLY have SP4?
> :)
>

HELP: SP4 Version?

I am convinced we do not have SQL 2000 SP4 installed but the console says I
do. After a few failed installation of SP4 I cannot imagine it is truly
installed.
It says: 8.00.2039 (SP4)
Do I REALLY have SP4?

@.@.version of 8.00.2039 seems correct.
"Whispering Leaf" wrote:

> I am convinced we do not have SQL 2000 SP4 installed but the console says I
> do. After a few failed installation of SP4 I cannot imagine it is truly
> installed.
> It says: 8.00.2039 (SP4)
> Do I REALLY have SP4?
>
>