Please post setup and installation questions in the Setup forum

Earlier versions of SQL had an icon in the system tray - which was very useful. I cannot seem to find how you activate this in 2005.

Also you could schedule a job MSDE 2000 to, say, backup a database. I can't find how you do this in SQL Express.

The system tray feature is no longer a component of SQL Server, Express contains no scheduler, please use the windows task scheduler to call sqlcmd instead.|||

While SQL 2005 no longer provides a system tray icon for the previous Server Manager applet, here is a link to a .NET application created as a replacement. (Usual craveats implied...)

SQL Server 2005 Service Manager Alternative
http://www.sqldbatips.com/showarticle.asp?ID=46

Also, SQL 2005 Express does not include the SQL Agent Job Scheduling service. You can verify at this version comparision:

SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

However, you could combine the use of Windows Scheduler and SQLCmd.exe to create a replacement and similar functionality with SQL 2005 Express.

Please post setup and installation questions in the Setup forum

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

There was also a feature in Visual Studio 2003 whereby we could view and manage the database present on the server(s) [I think it was called the SQL Enterprise Manager], and also a tool called the Query Analyzer where we could run queries on the databases. Are these also scrapped in VS 2005? What are the alternatives if that is the case?|||

How do I upgrade a SQL Server 2005 trial version with an expired license? I have a real license. If I install a new version, I don't want to lose the reports I created from the old version.

Thank you.

|||

Check out this article. If it's not already too late.

http://support.microsoft.com/?kbid=914158

|||Where is the "Setup Forum"?|||You can find the Setup forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 |||

Please help me to solve.

How to rectify following error

in Ms Access 2003 in windows20000

(It is working in XP)

"Microsoft Office Access can't open the database because it is missing,or opened exclusively by another user ".

|||When I run my setup.exe and get to the window for "components to install" the Reporting Services option is greyed out! Any ideas? The only thing I can think of is that the person who gave me the software (he isn't a DBA, and don't even ask why I have to go through him!!) gave me the wrong files? or downloaded some partial CD? I'm lost!|||It means you do not have one of the pre-req's, almost certainly IIS.

Please post setup and installation questions in the Setup forum

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

There was also a feature in Visual Studio 2003 whereby we could view and manage the database present on the server(s) [I think it was called the SQL Enterprise Manager], and also a tool called the Query Analyzer where we could run queries on the databases. Are these also scrapped in VS 2005? What are the alternatives if that is the case?|||

How do I upgrade a SQL Server 2005 trial version with an expired license? I have a real license. If I install a new version, I don't want to lose the reports I created from the old version.

Thank you.

|||

Check out this article. If it's not already too late.

http://support.microsoft.com/?kbid=914158

|||Where is the "Setup Forum"?
|||You can find the Setup forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 |||

Please help me to solve.

How to rectify following error

in Ms Access 2003 in windows20000

(It is working in XP)

"Microsoft Office Access can't open the database because it is missing,or opened exclusively by another user ".

|||When I run my setup.exe and get to the window for "components to install" the Reporting Services option is greyed out! Any ideas? The only thing I can think of is that the person who gave me the software (he isn't a DBA, and don't even ask why I have to go through him!!) gave me the wrong files? or downloaded some partial CD? I'm lost!|||It means you do not have one of the pre-req's, almost certainly IIS.

Please post setup and installation questions in the Setup forum

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

There was also a feature in Visual Studio 2003 whereby we could view and manage the database present on the server(s) [I think it was called the SQL Enterprise Manager], and also a tool called the Query Analyzer where we could run queries on the databases. Are these also scrapped in VS 2005? What are the alternatives if that is the case?|||

How do I upgrade a SQL Server 2005 trial version with an expired license? I have a real license. If I install a new version, I don't want to lose the reports I created from the old version.

Thank you.

|||

Check out this article. If it's not already too late.

http://support.microsoft.com/?kbid=914158

|||Where is the "Setup Forum"?|||You can find the Setup forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 |||

Please help me to solve.

How to rectify following error

in Ms Access 2003 in windows20000

(It is working in XP)

"Microsoft Office Access can't open the database because it is missing,or opened exclusively by another user ".

|||When I run my setup.exe and get to the window for "components to install" the Reporting Services option is greyed out! Any ideas? The only thing I can think of is that the person who gave me the software (he isn't a DBA, and don't even ask why I have to go through him!!) gave me the wrong files? or downloaded some partial CD? I'm lost!|||It means you do not have one of the pre-req's, almost certainly IIS.

Please post setup and installation questions in the Setup forum

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

There was also a feature in Visual Studio 2003 whereby we could view and manage the database present on the server(s) [I think it was called the SQL Enterprise Manager], and also a tool called the Query Analyzer where we could run queries on the databases. Are these also scrapped in VS 2005? What are the alternatives if that is the case?|||

How do I upgrade a SQL Server 2005 trial version with an expired license? I have a real license. If I install a new version, I don't want to lose the reports I created from the old version.

Thank you.

|||

Check out this article. If it's not already too late.

http://support.microsoft.com/?kbid=914158

|||Where is the "Setup Forum"?|||You can find the Setup forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 |||

Please help me to solve.

How to rectify following error

in Ms Access 2003 in windows20000

(It is working in XP)

"Microsoft Office Access can't open the database because it is missing,or opened exclusively by another user ".

|||When I run my setup.exe and get to the window for "components to install" the Reporting Services option is greyed out! Any ideas? The only thing I can think of is that the person who gave me the software (he isn't a DBA, and don't even ask why I have to go through him!!) gave me the wrong files? or downloaded some partial CD? I'm lost!|||It means you do not have one of the pre-req's, almost certainly IIS.

Please Help: SQL service cannot start

Hi
I created an account to run MS SQL services and give logon
locally and log on as service permission. Installation was
successful with this service account.
After a few hours later, SQL Agent service hang and cannot
restart. Error message is applicaion fail to initialize.
Therefore MS SQL server service also cannot restart.
When I use LocalSystem to start SQL services, everything
is fine.But I need to use service account because of
security reasons.
When I login with this service account, it immedialy
logout. I cannot login at all.
MS SQL 2000 standard edition with SP3.
Any suggestion is appreciated.
ThanksHi,
Add the user to "power users" group and try.
Thanks
Hari
MCDBA
"Ben" <anonymous@.discussions.microsoft.com> wrote in message
news:00a101c3b6a0$e3136eb0$a301280a@.phx.gbl...
> Hi
> I created an account to run MS SQL services and give logon
> locally and log on as service permission. Installation was
> successful with this service account.
> After a few hours later, SQL Agent service hang and cannot
> restart. Error message is applicaion fail to initialize.
> Therefore MS SQL server service also cannot restart.
> When I use LocalSystem to start SQL services, everything
> is fine.But I need to use service account because of
> security reasons.
> When I login with this service account, it immedialy
> logout. I cannot login at all.
> MS SQL 2000 standard edition with SP3.
> Any suggestion is appreciated.
> Thanks
>|||If when you login using thi sacount your session is terminated there is =clearly something wrong withthe account in some way. have you checked =the event log after your failed loginattempt - any error message =displayed?
Mike john
"Ben" <anonymous@.discussions.microsoft.com> wrote in message =news:00a101c3b6a0$e3136eb0$a301280a@.phx.gbl...
> Hi
> > I created an account to run MS SQL services and give logon > locally and log on as service permission. Installation was > successful with this service account.
> > After a few hours later, SQL Agent service hang and cannot > restart. Error message is applicaion fail to initialize.
> Therefore MS SQL server service also cannot restart.
> When I use LocalSystem to start SQL services, everything > is fine.But I need to use service account because of > security reasons.
> > When I login with this service account, it immedialy > logout. I cannot login at all. > > MS SQL 2000 standard edition with SP3.
> > Any suggestion is appreciated.
> > Thanks
> >|||Hi ben,
If i understand properly, this is what you need... please
refer the article -
http://support.microsoft.com/default.aspx?kbid=283811
it clearly says what permissions u need for the os level
id to start sqlserver.
but to have a short cut - please have an id in the
administrator's group to start mssql server if u do not
want to start with localsystem
regards,
bharath
mcdba
>--Original Message--
>Hi,
>Add the user to "power users" group and try.
>Thanks
>Hari
>MCDBA
>
>"Ben" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00a101c3b6a0$e3136eb0$a301280a@.phx.gbl...
>> Hi
>> I created an account to run MS SQL services and give
logon
>> locally and log on as service permission. Installation
was
>> successful with this service account.
>> After a few hours later, SQL Agent service hang and
cannot
>> restart. Error message is applicaion fail to initialize.
>> Therefore MS SQL server service also cannot restart.
>> When I use LocalSystem to start SQL services, everything
>> is fine.But I need to use service account because of
>> security reasons.
>> When I login with this service account, it immedialy
>> logout. I cannot login at all.
>> MS SQL 2000 standard edition with SP3.
>> Any suggestion is appreciated.
>> Thanks
>>
>
>.
>

Please help.....

We had a NT4 server with SQL 7 installed. AS it happened the machine complete
bombed out. I managed to copy the data folder from the SQL installation
diretory before the whole hdd went up in flames.
I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
and I really want to import this database into SQL 2000.
I have attached the database succefully and can see it there. Even the OBDC
test is successfull. However the application which is CRM Superoffice doens;t
want to log on as it says invalid username and password.
I am sure that I might have missed seomthing. Do I first need to some
coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
we no longer have SQL 7 but just the data directory of that installation. No
backups were done of this machine ( as usual )
Can I do anything at all?
Please, any help is appreciated.
Regards
GianGian
Did you move all logins from source database to the destination?
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Sounds like the database is fine, but you may need to reattach database user
accounts.
See sp_change_users_login to see if you just need to realign the database
user accounts with the logins
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Hi,
Since you did an attach of databases, I am sure that you have not moved the
system databases from sql 7 to sql 2000.
All the SQL server logins will be kept in master database. So since you have
not copied the logins the SID in syslogins will not
match with SID in sysusers of each database. To resync the syslogins with
sysusers, refer the procedure "sp_change_users_login"
in sql server books online.
One more thing is after sync. you may need to make the CRM user to default
to that user database using the below system procedure
sp_defaultdb 'login_name','database_name'
Thanks
Hari
MCDBA
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Gian,
Things to check.
1) Did you import all the logins from the old server?
2) Are the logins mapped to the correct users in your attached database?
sp_change_users_login can help here.
3) Is the security mode the same as the old server? i.e. are you using
Windows Authentication Only or Mixed mode? Check that this is correct
because a standard SQL login will not be allowed on a Windows
Authentication Only server.
Also have a look at:
Microsoft Knowledge Base Article - 224071
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/?id=224071
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gian wrote:
> We had a NT4 server with SQL 7 installed. AS it happened the machine complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the OBDC
> test is successfull. However the application which is CRM Superoffice doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
> we no longer have SQL 7 but just the data directory of that installation. No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian