Activity overview
Latest activity by SimonMartin
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
Where can I download Version 5
I need to re-install SQL Compare 5 but can't find it to download anywhere. Where should I be looking?
TIA
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?
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...
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 ...
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...
integrated security
I have sql prompt 3.6 and am trying to connect to my local Sql Express. The connection from Visual Studio to the SQL Express instance is using integrated security but there doesn't seem to be an op...