ASP .Net / SQL Server 2000 Connection Problems [Resolved]

I've tried searching for my answer on the forums - and all I can find is Access questions..

My problem is, I assume my connection string, I get an error upon executing my VB.Net/ASP.Net project and i've tried rewriting it [connection string] and still no luck..

My server (Machine) name = THEBEAST 'It's a local server
My Named SQL Server Instance = BEASTDATA
The Database i've created for this project = House_db
The Username = House_DBUsr
The Passsword = nottellin


I've created the user - and i'm using SQL Server 2000 authentication.

When the page loads, I want it to connect to the server - grab some data - and then close the connection.. and for some reason I get the error "Database does not exist or access denied"

VB Code:

Dim mySqlConnection As New SqlConnection()
        mySqlConnection.ConnectionString = "Data Source=(local); initial Catalog=House_db; Integrated Security=SSPI"
        mySqlConnection.Open()
        MsgBox("Success")
        mySqlConnection.Close()

I got the same error with this Con string.

"Server=(local);Database=House_db;Uid=House_DBUsr;Pwd=nottellin;"

I got that from connection strings.com

The user, has of course, been created on my SQL server installation - as well as the DB.

Any suggestions?

And yes, I've Imported the System.Data.SqlClient namespace(s)

-Kedaeus-

This is caused by not setting the correct permissions in SQL Server.

Make sure you give the appropriate user (probably ASPnet user) permissions on the database you are using.

Thank you :)