SQLExpress w/Beta 2 VS -- Can't Create DB
We have a clean Windows XP Install w/ Visual Studio 2005 Beta 2.
I can not create a new database with SQLExpress...
We have also been trying to connect to Oracle 10g.. And we constantly get cannot find TNS Names.ora, but we have easily configured this with another clean machine with VS.NET 2003..
What gives with 2005...I can't connect it to any database other than a SQLServer 2000 on another machine....
Please help!!!
[431 byte] By [
snesbit] at [2008-2-14]
How are you going about creating the database? Are you adding a database connection or are you creating this from a tool like SQLCMD? Check the SQL Server Express service and make sure its started. The default instancename is "sqlexpress" so your connection strings should look something like, "Server=.\sqlexpress"
Same issue here. I create a new web site from ASP.NET template in VS 2005 beta. sqlservr.exe is running as a Network Service. I have full administrative rights to the computer on which I installed VS 2005.
I select Add New Item -> SQL Database. Give it a name and place and OK. Then this error comes up (Access Denied).
I had given full text of the error here:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=76715
Can somebody enligten me?
Well , I found one Online Book here and downloaded it. Will browse to see what I am doing wrong.