Could not create new Database.Login failed for user "Nothadoth". Reason: Not assosiated with a trusted SQL Server connection
Can somebody help?
Thanks,
Noth
(Btw: This error occured when I was manually trying to connect my VBPortal to a DB)The root of your problem is most likely in your connection string. More importantly, what authentication are you trying to use when connecting to SQL (Windows or SQL)? The error leads me to believe you are using Windows authentication, where you probably should be using SQL Authentication if your app is on the net. IF you want to use SQL Authentication would have to have been set up when you installed SQL Server. Do you have an "sa" account and password? If so then your SQL Instance is set up for SQL Authentication.|||It asked me for an SA Password. That's it.
And yes, i'm using SQL Authentication.|||can you post the connection string that you are using.|||I've just checked the problem.
What i'm trying to do is create a database through the file PortalDB.sql
Please help, I need this up by tomorrow
Cheers,
Noth|||I need to see code to help.|||My MSN is: nothadoth_@.hotmail.com
my AIM: nothadoth12
Yahoo: nothadoth
There are some contacts, please add me if you can.
---
Someone told me that I needed to create it in the Start>Run>Cmd
He said input this code: OSQL -E -i D:\PortalVB\PortalDB.sql
(-E means Trusted Connection)
When I put that in, this happened.
[I cannot copy the code it's self because the CMD won't let me copy :( ]
It said:
Msg 1801, Level 16, State 3, Server FRED, Line 8, Database 'Portal' already exists.
After that a load of numbers just appeared, then varied from around 1-699 or so, and looked like this.
1> 2> 3> 2> 2> 1>
Then eventualy it said:
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
<1 Row Affected>
Then I tried doing the IBuySpy setup again and it said "Configuration Failed" when trying to create a database.