![]() ![]() Under securables it's a taf different from 2017 but the only thing selected for my SERVER is Connect SQL - Grantor sa, Grant ticked. I don't know if there is something I need to tick/select in 2019 that wasn't in 2017 but it is exactly the same password, copied and pasted AND typed. ![]() It's the nearest I can get as it's got past the server but the login is not working, I have mapped it in to my DB as a dbdatareader / public and default DB Brainiac / dbo, but it just doesn't work. SERVER=ROB2022\SQLEXPRESS DATABASE=brainiac uid=brainiac pwd=bxxxxx SERVER=ROB2022\SQLEXPRESS (ROB2022\rober) DATABASE=brainiac uid=brainiac pwd=bxxxxx I tried my SQL login that I recreated, relinked and chose the exact same settings as the old DB, schema DBO, Default DB > Brainiac and only Read/Exec permissions.īut when I try all these in the connection string they fail with these errors: (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Verify that the instance name is correct and that SQL Server is configured to allow remote connections. The server was not found or was not accessible. SERVER=HP\LOCALDB#9190A7A7 DATABASE=brainiac uid=ROB2022/Rober Ī network-related or instance-specific error occurred while establishing a connection to SQL Server. I did somewhere for a second see, and log, HP\LOCALDB#9190A7A7 I guess that is the instance of the installation but when I tried it in the connection string Running SELECT select user_name() I get dbo I can login to the DB in SQL Management Studio with my Windows details > ROB2022\SQLEXPRESS (user blanked out ROB2022\rober) in properties under connection it says ROB2022\SQLEXPRESS (ROB2022\rober) On the new computer, I am getting loads of errors when trying to run the app. The old one worked fine with the SQL Connection login (read/exec on CUD procs), I would login to the DB SQL management console with my OLD Windows login > (LocalDB)\MSSQLLocalDB (user blanked out HP\Reid) and the app would use the SQL connection string > SERVER=(LocalDB)\MSSQLLocalDB DATABASE=brainiac uid=brainiac pwd=bxxxxx EXE that hooks into a DLL where the connection string is in a GetSettings.cs class. I have a VS C# project that is trying to login to the DB. I have created the logins and linked them to the users that were orphaned in the backup DB/Restore process as it was quicker with an external drive to copy and set up than trying to do loads of inserts/creates etc. The old one had SQL 2017 on it the new one SQL Express 2019. I am trying to migrate a DB from an old dying laptop to a new one, both HPs. ![]()
0 Comments
Leave a Reply. |