I am setting up a web application, where the application needs to access a
database. I have created the user (for the application) and it can log in to
the SQL 2005 Sp2 server, but when I try to open the required database using
Server Management Studio, it says "The database [name] is not accessible.
(ObjectExplorer)"
How do I make a database accessible to a login, using Server Management
Studio?
Re: SQL Express MDF file moved from 1 computer to another - auth f ... I try to attach the database which is located in MyDocuments\Visual ...Microsoft SQL Server Management Studio... now it tells me that authentication has failed for my windows ... (microsoft.public.sqlserver.connect)
Re: SQL Express MDF file moved from 1 computer to another - auth f ... I try to attach the database which is located in MyDocuments\Visual ...Microsoft SQL Server Management Studio... now it tells me that authentication has failed for my windows ... (microsoft.public.sqlserver.connect)
Re: how to make a database accessible to a user ... For each database, go to security>Roles>Database Roles and ensure the role minimal exists. ... Ensure that the user properties, within the monitor database, for view, shows the database role membership as minimal. ... If I set the default database for view to be master, then when I log in as view, then I can login.... I have created the user and it can log in to the SQL 2005 Sp2 server, but when I try to open the required database using Server Management Studio, it says "The database is not accessible. ... (microsoft.public.sqlserver.setup)
Re: Creating a database in Compact edition? Help>>>>> ... Use the SqlCeEngine object to create a database in code. ... Setup syncronization with a SQL Server Workgroup or better DBMS. ... The Express edition of SQL Server Management Studio does not support CE. ... (microsoft.public.sqlserver.ce)
Re: need to include sql database with published project ...SQL Server Management Studio Express, ... My remaining problem is how to include the SQL Database as part of the ... I have transferred the .mdf and transaction files to the target machine,... (microsoft.public.vstudio.development)
