Comments
Sort by recent activity
Hi Simon,
Got it now.
Many thanks [image] / comments
Hi Simon,
Got it now.
Many thanks
Hi Chris,
Thank you for getting back to me. I have tried the link both through my browser and connecting to it with my FTP client but I can't see the folder / comments
Hi Chris,
Thank you for getting back to me. I have tried the link both through my browser and connecting to it with my FTP client but I can't see the folder
Hi Brian,
Thanks for sorting that out.
Having installed Management Studio I can do everything I need (and its quicker at interacting with the database than Visual Studio) and I get SQL Prompt working as well - so I'm happy [image]
Simon / comments
Hi Brian,
Thanks for sorting that out.
Having installed Management Studio I can do everything I need (and its quicker at interacting with the database than Visual Studio) and I get SQL Prompt worki...
Ok - I've installed Management Studio (didn't realise there was a free version I've only used the full version for SQL Server)
When using Management Studio I am able to get SQL Prompt to authenticate. But I can't then use Visual Studio to connect to the database. So after closing Management Studio and opening a Sproc in Visual Studio I am asked to authenticate for SQL Prompt, it fails to authenticate... and leaves nothing in either the logs (that I can see, my logs are totally empty) or in Event Viewer / comments
Ok - I've installed Management Studio (didn't realise there was a free version I've only used the full version for SQL Server)
When using Management Studio I am able to get SQL Prompt to authentica...
I don't have Management Studio - does it come with Visual Studio? / comments
I don't have Management Studio - does it come with Visual Studio?
I haven't created any users for the SQL Express database.
I created the database from Visual Studio and with the integrated security connection string I can see all my tables, sprocs etc.
So would I need to create another user in order to authenticate with SQL Prompt, can't it also use the integrated security that Visual Studio is using? / comments
I haven't created any users for the SQL Express database.
I created the database from Visual Studio and with the integrated security connection string I can see all my tables, sprocs etc.
So would ...
It does make a difference when I use 127.0.0.1 as the server name (it takes longer to check); but unfortunately it still fails to authenticate. However when trying to browse for the .mdf file to connect to it throws up an error about remote connections not being allowed.
There doesn't appear to be a "logins" node in Visual Studio for the Sql Express, so I don't think I can even add a user that way.
Using my windows logon name (prefixed and not prefixed with machine name) and password does not authenticate either. / comments
It does make a difference when I use 127.0.0.1 as the server name (it takes longer to check); but unfortunately it still fails to authenticate. However when trying to browse for the .mdf file to c...
When it tries to authenticate a message appears saying
"Authentication Failed"
It isn't a failure of the product. Rather a failure to connect to the SQL Express database using Windows Authentication which I have chosen as there is no option for Integrated Security which is how my Windows form is connecting to the database. / comments
When it tries to authenticate a message appears saying
"Authentication Failed"
It isn't a failure of the product. Rather a failure to connect to the SQL Express database using Windows Authenticatio...