19-05-2021, 05:11 PM
(This post was last modified: 19-05-2021, 05:17 PM by supermop2000.)
I've run into some major headaches trying to setup my ASG RD environment to use SQL Express remotely. I've been using a local SQL Express environment for some time on one of my terminal servers at work. However, I am now needing to push this out to some more of my team, so I figured I'd just get everyone on the same master database that I've been using on the SQL Express instance.
I'm not exactly new to MSSQL - been a sysadmin for over 12 years looking after SQL among many other, and I've even ran an ASG RD database before, except this was on full blown SQL at my previous employer.
I have enabled SQL Express to be remotely accessed via SQL config manager (enabling the named pipes and TCP/IP services, and restarted), and setup a security group on our domain to have full SA rights on the SQL Express instance, as well as explicit full permissions to the ASG database. I run into an issue when trying to set up ASG remotely - I enter the server name, database name, and use integrated authentication (the user is in the group configured earlier), and the test connection is successful. As soon as I hit ok to confirm it all, I get an error message every single time saying "Object reference not set to an instance of an object". I'm no SQL error expert, but that make no sense at all.
I never had this issue using full blown SQL - is there anything I'm doing wrong here??
EDIT: I am trying to paste screenshots, but this message board is very broken - pasted images just convert to weird encrypted ASCII strings.....
I'm not exactly new to MSSQL - been a sysadmin for over 12 years looking after SQL among many other, and I've even ran an ASG RD database before, except this was on full blown SQL at my previous employer.
I have enabled SQL Express to be remotely accessed via SQL config manager (enabling the named pipes and TCP/IP services, and restarted), and setup a security group on our domain to have full SA rights on the SQL Express instance, as well as explicit full permissions to the ASG database. I run into an issue when trying to set up ASG remotely - I enter the server name, database name, and use integrated authentication (the user is in the group configured earlier), and the test connection is successful. As soon as I hit ok to confirm it all, I get an error message every single time saying "Object reference not set to an instance of an object". I'm no SQL error expert, but that make no sense at all.
I never had this issue using full blown SQL - is there anything I'm doing wrong here??
EDIT: I am trying to paste screenshots, but this message board is very broken - pasted images just convert to weird encrypted ASCII strings.....