Unable to connect to local SQL db
Hi, I downloaded Rapid Miner and I am really curious if it can help with my task of data analysis. However, I cannot connect to my local MS SQL Express database. I've set up the url which looks like this:
jdbc:sqlserver://localhost:1433;databaseName={DbName};integratedSecurity=true;
and when I don't provide the name of DB connection works well, but I have no possibility to access the data, since I am then not connected to a specific database. However, once I specify the name of DB I receive following error message:
Cannot open database "DbName" requested by the login. The login failed. ClientConnectionId:1ead8148-9161-45d6-996b-abab22121
Anyone has any suggestions what steps to take to resolve the problem?
Thanks
Marcin
jdbc:sqlserver://localhost:1433;databaseName={DbName};integratedSecurity=true;
and when I don't provide the name of DB connection works well, but I have no possibility to access the data, since I am then not connected to a specific database. However, once I specify the name of DB I receive following error message:
Cannot open database "DbName" requested by the login. The login failed. ClientConnectionId:1ead8148-9161-45d6-996b-abab22121
Anyone has any suggestions what steps to take to resolve the problem?
Thanks
Marcin