Using Project Type: Database, Add New Item: Stored PRoc ...
When in the Server Explorer\Data Connections the database has been added and
it is possible to navigate the treel
However after entering and saving TSQL the selecting Project\Run the
following error message is displayed.
---------------------------
Microsoft Visual Studio
---------------------------
Cannot open database "dbname" requested by the login. The login failed.
Login failed for user 'domain\usename'.
---------------------------
OK
---------------------------
Hi Vakar,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you encounter the error message Login
failed for user 'domain\usename'. when trying creating stored procedure
scripts. If I have misunderstood your concern, please feel free to point it
out.
This seems to be a login issue with SQL Server 2005. Please make sure the
connection you are using have the right permission to login the server, to
create stored procedures.
If you use this domain\username to login via SQL Server Management Studio,
is it possible for you to login and create the stored proceudres?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.