Re: installing help for sql 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Atul,
It sounds like the the restore operation has created orphaned users. That
is, you have database users that are not mapped correctly to logins. See if
this Books Online topic fixes the problem for you.
http://msdn2.microsoft.com/en-us/library/ms175475.aspx
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx


"atuljoshi" <atuljoshi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3CC152E2-195A-4380-9E93-CBFE2C758628@xxxxxxxxxxxxxxxx
Hi gail,

Thanks for your great help. Now i installed the sql server2005 on one of
my
server and its running fine but i am now getting an other problem which is
I've restored my database from a different server and all the users in
security are set up but when I try to assign the user to that database I
get
an error that "its already assigned". When I check the properties for
that
user and check the User Mapping, my database is unchecked. and when i am
tried to check the dbowner the its keep giving me this error msg

"Create Failed for User 'MyUser'. (Microsoft.SqlServer.Smo)" "User or role
'MyUser' already exists in the current database

--
Atul


"Gail Erickson [MS]" wrote:

Thanks for your help this i already know, But i need step by step
installation help with snap shots because i installed the sql server
2005
before but when i installed it afetr some time it gave my few errors
like
unable to connet through remote services and also the error od dead
lock.

In the future, please provide ALL relevant information in your initial
post.
This will reduce the amount of time spent trying to solve your problems
and
responders will not have to guess at what you are trying to accomplish.

In SQL Server 2005, remote connections are disabled by default. Use the
Surface Area Configuration tool to enable remote connections. If you
continue to get errors after enabling remote connections, please provide
the
exact error message(s) you're getting.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no
rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx


"atuljoshi" <atuljoshi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:590D9E97-3583-40F1-9056-960013AB246E@xxxxxxxxxxxxxxxx
HI,
Thanks for your help this i already know, But i need step by step
installation help with snap shots because i installed the sql server
2005
before but when i installed it afetr some time it gave my few errors
like
unable to connet through remote services and also the error od dead
lock.
Right now i am using sql 2000 but i never got this type of error
before.
PLease help he me to sort this problem.
Thanks
--
Atul


"Gail Erickson [MS]" wrote:

I am tiring to install sql 2005 on my new server, which has 2003
enterprise
edition. Can some one provide me step by step help for installing
sql
2005
on
my machine?
--
Here's the Books Online topic that walks you through the procedure.
http://msdn2.microsoft.com/en-us/library/ms143219.aspx

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no
rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx


"atuljoshi" <atuljoshi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2298D6F4-8C9C-48A7-A79D-76E53F53EB30@xxxxxxxxxxxxxxxx
Hi there,
I am tiring to install sql 2005 on my new server, which has 2003
enterprise
edition. Can some one provide me step by step help for installing
sql
2005
on
my machine?
--
Atul








.

Relevant Pages

  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL SERVER 2008 Express + SP1
    ... I installed the SQLXPR_X64, and before I attempted the SP1, SQLEXPRESS database was 64bit for the configuration, better yet the repair do work anymore because SP1 changed them somehow to 32 and the original install was 64 ... If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. ... And regarding your sql server installation, ...
    (microsoft.public.sqlserver.setup)
  • Re: Cluster will not fail over.
    ... As far as the TCP/IP issue goes, you had to rebuild the cluster and were not ... able to restore the master database. ... the entire installation configuration just as if nothing was running on it. ... > This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: End User Requirements
    ... running MS-Access and not needing the full access installation, ... you are considering running a local copy of SQL server database. ...
    (microsoft.public.sqlserver.programming)
  • Re: smo create database object
    ... method to create a new sql server database with sql server 2005 ... I've tried the surface area configuration tool, but the database ... When you run the Surface Area Configuration, ... Set it to accept local and remote connections. ...
    (microsoft.public.dotnet.languages.csharp)