Issue With Get-Datbases function

[jeffw59]

I have installed the PSSQLIB module but I have an issue with named SQL instances when executing the Get-Databases function.

For SQL Server installed on the default MSSQLSERVER instance the module returns the database information as expected but for named instances I get an Error:Failed to connect to server.

I tried removing the port from the connect string and that worked for named instances on the default port 1433 but for instances on a none standard port the connection still fails.

Any suggestions would be appreciated.

Thanks and regards.

[sanderstad]

Hi Jeff, Very good that you use my module to automate your tasks. Unfortunately I don’t actively develop this project anymore and have concentrated my efforts towards the dbatools project. The dbatools module has a wide variety of commands and is better maintained than I could ever do by myself. That’s the reason I can no longer maintain this project and I don’t intend to do so in the near future. The dbatools module has a command called Get-DbaDatabase to get all your databases. If you want the dbatools module, it’s completely free and developed by people like me from all over the world. The link to the website: https://dbatools.io/ If you have any trouble with it let me know I’ll try to help you out. With kind regards, Sander Stad From: jeffw59 [mailto:[email protected]] Sent: Tuesday, December 05, 2017 5:30 AM To: sanderstad/PSSQLLib <[email protected]> Cc: Subscribed <[email protected]> Subject: [sanderstad/PSSQLLib] Issue With Get-Datbases function (#2) I have installed the PSSQLIB module but I have an issue with named SQL instances when executing the Get-Databases function. For SQL Server installed on the default MSSQLSERVER instance the module returns the database information as expected but for named instances I get an Error:Failed to connect to server. I tried removing the port from the connect string and that worked for named instances on the default port 1433 but for instances on a none standard port the connection still fails. Any suggestions would be appreciated. Thanks and regards. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#2> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AF3q5QceRrHDILmol42jAMvMVZKiTX0wks5s9MbNgaJpZM4Q1t-8> . <https://github.com/notifications/beacon/AF3q5VLph8FZjwSVqXQ8iPlUpRTC-MZHks5s9MbNgaJpZM4Q1t-8.gif>

[jeffw59]

Hi Sander Thanks for taking the time to reply. I will certainly follow your suggestion to use dbatools. Cheers Jeff Willson

…

________________________________ From: Sander Stad <[email protected]> Sent: Tuesday, 5 December 2017 9:18 PM To: sanderstad/PSSQLLib Cc: jeffw59; Author Subject: Re: [sanderstad/PSSQLLib] Issue With Get-Datbases function (#2) Hi Jeff, Very good that you use my module to automate your tasks. Unfortunately I don’t actively develop this project anymore and have concentrated my efforts towards the dbatools project. The dbatools module has a wide variety of commands and is better maintained than I could ever do by myself. That’s the reason I can no longer maintain this project and I don’t intend to do so in the near future. The dbatools module has a command called Get-DbaDatabase to get all your databases. If you want the dbatools module, it’s completely free and developed by people like me from all over the world. The link to the website: https://dbatools.io/ If you have any trouble with it let me know I’ll try to help you out. With kind regards, Sander Stad From: jeffw59 [mailto:[email protected]] Sent: Tuesday, December 05, 2017 5:30 AM To: sanderstad/PSSQLLib <[email protected]> Cc: Subscribed <[email protected]> Subject: [sanderstad/PSSQLLib] Issue With Get-Datbases function (#2) I have installed the PSSQLIB module but I have an issue with named SQL instances when executing the Get-Databases function. For SQL Server installed on the default MSSQLSERVER instance the module returns the database information as expected but for named instances I get an Error:Failed to connect to server. I tried removing the port from the connect string and that worked for named instances on the default port 1433 but for instances on a none standard port the connection still fails. Any suggestions would be appreciated. Thanks and regards. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#2> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AF3q5QceRrHDILmol42jAMvMVZKiTX0wks5s9MbNgaJpZM4Q1t-8> . <https://github.com/notifications/beacon/AF3q5VLph8FZjwSVqXQ8iPlUpRTC-MZHks5s9MbNgaJpZM4Q1t-8.gif> — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsanderstad%2FPSSQLLib%2Fissues%2F2%23issuecomment-349259522&data=02%7C01%7C%7C9b2df0ef6d6b4983572d08d53bc981c0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636480659003706734&sdata=8hrrM1J3TuPUuPvNt9rR9%2F4cA22gAkih%2B0NYefzTWvA%3D&reserved=0>, or mute the thread<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAVR0N75uoDRoVkZik7b-VVO1uqeBMHwcks5s9RhqgaJpZM4Q1t-8&data=02%7C01%7C%7C9b2df0ef6d6b4983572d08d53bc981c0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636480659003706734&sdata=Yh7FsnnJAfumcCCigrn1sn5ynhSh05sGp9cKzViPSI4%3D&reserved=0>.