dfrontiera Posted October 9, 2022 Share Posted October 9, 2022 Hi All, Newbie here. I've installed the docker "MY-SQL-Server" and it installed just fine, no issues. But when I go to do the initial login I get issues of it not being seen. Current Settings for the docker: When I then go into SMSS and enter in the server name I get an error (See below). I've tried to browse to my network but it doesn't see it. I'm not sure what I'm missing. I am new to running a server so it's very possible I'm missing a bunch of things, or maybe did something wrong. Any help would be greatly appreciated!! Error msg Quote Link to comment
dfrontiera Posted October 12, 2022 Author Share Posted October 12, 2022 Just giving this question a bump. Also adding the logs from the SQL Server container in hopes that might help. I've also noticed that on my SSMS side if I attempt to browse the local or network servers nothing shows up. I've attempted to to install SQL Server following the instructions from https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash but still same error as above. I'm still very new to having a server so there could be things I'm missing. Any help would be GREATLY APPRECIATED. Quote Link to comment
Solution Derek Posted October 19, 2022 Solution Share Posted October 19, 2022 On 10/12/2022 at 5:34 PM, dfrontiera said: Just giving this question a bump. Also adding the logs from the SQL Server container in hopes that might help. I've also noticed that on my SSMS side if I attempt to browse the local or network servers nothing shows up. I've attempted to to install SQL Server following the instructions from https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash but still same error as above. I'm still very new to having a server so there could be things I'm missing. Any help would be GREATLY APPRECIATED. In Sql server management studio, make sure for a server name you use the unraid server name or IP address. You can also append ,1433 on the end of the server name to give it an extra hint to use TCP/IP to connect. For example, connecting to an ip of 192.168.0.200 you would specify: 192.168.0.200,1433 you also need to select SQL server authentication from the authentication dropdown (so that the username/password boxes become writable) username is: sa password is: <whatever you configured on the docker config page> Good luck! Quote Link to comment
dfrontiera Posted October 20, 2022 Author Share Posted October 20, 2022 Thanks! I was using windows login. That was the issue. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.