I use the Mangement Studio Express to manage a MSDE 2000 instance and notice that the Server authentication area in the Security is disabled for that instance. But for an Express instance, the Server authentication area is enabled. Is this difference caused by some settings
Thanks,
Peter
Cannot change server authentication in Management Studio Express
Hot Topic
- SSAS 2005 Not Starting - Running under Vista with SQL 2005 SP2 installed
- Can we Bind the DataSet dynamically to the Deployed Report into the ReportServer
- Service problems after SP1 upgrade
- Users Folders
- Calculated measu Currency value with currency code
- output one row
- Bulk Insert performance
- Need SQL server advice
- Upgrade scripts for SQL Server Mobile Databases
- how to include the nulls??
SQL Server
- Microsoft.SqlServer.Dts.Runtime ASP.NET Security Issue
- XQuery to return multiple rows for the same node
- server timeout
- I solved the problem..
- UPDATE Method
- Adding DataSet as DataSource to Report Published on Report Server from ClientSide
- locking ramification of insert ... select ...
- INSERTING Data From Server to Server
- Script task
- New Query button -- always prompts for authentication
Cannot change server authentication in Management Studio Express
Raymond Dalton
You will more then likley find that there are several differences in the way that the engine handles things. In this some of the features and systems that the management studio uses will not work on the older engines. For example the maintenance plans as we know them in sql server 2000 can not be created in the sql server management studio.... but they can be maintained and edited if you create them using one onf the sql server 2000 tools.
Nisa
Hi Glenn,
You're definitely right about how the engine works differently. So far, I have fixed another issue by adding BackupDirectory to MSDE instance so I can backup MSDE instance in Management Studio.
Peter
Hoang Nguyen
Hi Glenn,
I have resolved this issue by changing LoginMode from 0 to 2. This seems to be a change in behavior. In SQL Server 2000, it won't affect the Enterprise Manager.