Hello all,
Here's my situation:
I have a single RDL file that describes a certain report.
I have different databases on different computers with the same tables
but different data in each table.
I need people to go to each computer, run the same RDL file, but have
it show the data that is specific to their database.
For instance, there is a single .rdl file which describes a personnel
report, and i want people at site A to only see info about site A's
personnel, and people at site B to only see info about site B's
personnel.
Is this possible? If so, is there any advice you can give me to help do
this? Thank you.
Kevin Green
Software Engineer
Pragmatech SoftwareOn each computer have an rds file specifying the connection properties for
that computer.
"KevinGreen24@.gmail.com" wrote:
> Hello all,
> Here's my situation:
> I have a single RDL file that describes a certain report.
> I have different databases on different computers with the same tables
> but different data in each table.
> I need people to go to each computer, run the same RDL file, but have
> it show the data that is specific to their database.
> For instance, there is a single .rdl file which describes a personnel
> report, and i want people at site A to only see info about site A's
> personnel, and people at site B to only see info about site B's
> personnel.
> Is this possible? If so, is there any advice you can give me to help do
> this? Thank you.
> Kevin Green
> Software Engineer
> Pragmatech Software
>|||Well we're working of a SaaS model, so every end user is running a thin
client, so we're not installing anything on the end user's computer.
magendo_man wrote:
> On each computer have an rds file specifying the connection properties for
> that computer.
> "KevinGreen24@.gmail.com" wrote:
> > Hello all,
> >
> > Here's my situation:
> >
> > I have a single RDL file that describes a certain report.
> >
> > I have different databases on different computers with the same tables
> > but different data in each table.
> >
> > I need people to go to each computer, run the same RDL file, but have
> > it show the data that is specific to their database.
> >
> > For instance, there is a single .rdl file which describes a personnel
> > report, and i want people at site A to only see info about site A's
> > personnel, and people at site B to only see info about site B's
> > personnel.
> >
> > Is this possible? If so, is there any advice you can give me to help do
> > this? Thank you.
> >
> > Kevin Green
> > Software Engineer
> > Pragmatech Software
> >
> >|||Are the databases on two different SQL servers? How do the users run the
report? From Report Manager, or embedded in a web page?
If they are running the reports from Report Manager on different servers
then you need to set up data sources (i.e. rds files) on each, with the same
name, but pointing to the site-specific database.
"KevinGreen24@.gmail.com" wrote:
> Well we're working of a SaaS model, so every end user is running a thin
> client, so we're not installing anything on the end user's computer.
> magendo_man wrote:
> > On each computer have an rds file specifying the connection properties for
> > that computer.
> >
> > "KevinGreen24@.gmail.com" wrote:
> >
> > > Hello all,
> > >
> > > Here's my situation:
> > >
> > > I have a single RDL file that describes a certain report.
> > >
> > > I have different databases on different computers with the same tables
> > > but different data in each table.
> > >
> > > I need people to go to each computer, run the same RDL file, but have
> > > it show the data that is specific to their database.
> > >
> > > For instance, there is a single .rdl file which describes a personnel
> > > report, and i want people at site A to only see info about site A's
> > > personnel, and people at site B to only see info about site B's
> > > personnel.
> > >
> > > Is this possible? If so, is there any advice you can give me to help do
> > > this? Thank you.
> > >
> > > Kevin Green
> > > Software Engineer
> > > Pragmatech Software
> > >
> > >
>|||Also in RS 2005 you can dynamically change the datasource based on the user.
I haven't done this but it is one of the capabilities.
Bruce Loehle-Conger
"magendo_man" <magendoman@.discussions.microsoft.com> wrote in message
news:BCD91F31-A84B-40D2-8B00-2FB36C53CD52@.microsoft.com...
> Are the databases on two different SQL servers? How do the users run the
> report? From Report Manager, or embedded in a web page?
> If they are running the reports from Report Manager on different servers
> then you need to set up data sources (i.e. rds files) on each, with the
> same
> name, but pointing to the site-specific database.
> "KevinGreen24@.gmail.com" wrote:
>> Well we're working of a SaaS model, so every end user is running a thin
>> client, so we're not installing anything on the end user's computer.
>> magendo_man wrote:
>> > On each computer have an rds file specifying the connection properties
>> > for
>> > that computer.
>> >
>> > "KevinGreen24@.gmail.com" wrote:
>> >
>> > > Hello all,
>> > >
>> > > Here's my situation:
>> > >
>> > > I have a single RDL file that describes a certain report.
>> > >
>> > > I have different databases on different computers with the same
>> > > tables
>> > > but different data in each table.
>> > >
>> > > I need people to go to each computer, run the same RDL file, but have
>> > > it show the data that is specific to their database.
>> > >
>> > > For instance, there is a single .rdl file which describes a personnel
>> > > report, and i want people at site A to only see info about site A's
>> > > personnel, and people at site B to only see info about site B's
>> > > personnel.
>> > >
>> > > Is this possible? If so, is there any advice you can give me to help
>> > > do
>> > > this? Thank you.
>> > >
>> > > Kevin Green
>> > > Software Engineer
>> > > Pragmatech Software
>> > >
>> > >
>>|||We host 1 report server which each client browser will access. We host
1 database server which has databases which hold the information for
each company that uses our product. So basically we host the data for
each company and we host the report server.
Each client browser will connect to the report server, and at that time
the appropriate company database will be accessed and the information
retrieved, along with the common .rdl file, and the appropriate report
rendered.
So there's 1 .rdl file which describes the form of the report, and
there are N databases for the N companies that use the product, which
hold the data. I need the 1 .rdl file to be able to display information
from any of the N databases that we have, based on the company that's
trying to access the report.
Does this make sense?
magendo_man wrote:
> Are the databases on two different SQL servers? How do the users run the
> report? From Report Manager, or embedded in a web page?
> If they are running the reports from Report Manager on different servers
> then you need to set up data sources (i.e. rds files) on each, with the same
> name, but pointing to the site-specific database.
> "KevinGreen24@.gmail.com" wrote:
> > Well we're working of a SaaS model, so every end user is running a thin
> > client, so we're not installing anything on the end user's computer.
> >
> > magendo_man wrote:
> > > On each computer have an rds file specifying the connection properties for
> > > that computer.
> > >
> > > "KevinGreen24@.gmail.com" wrote:
> > >
> > > > Hello all,
> > > >
> > > > Here's my situation:
> > > >
> > > > I have a single RDL file that describes a certain report.
> > > >
> > > > I have different databases on different computers with the same tables
> > > > but different data in each table.
> > > >
> > > > I need people to go to each computer, run the same RDL file, but have
> > > > it show the data that is specific to their database.
> > > >
> > > > For instance, there is a single .rdl file which describes a personnel
> > > > report, and i want people at site A to only see info about site A's
> > > > personnel, and people at site B to only see info about site B's
> > > > personnel.
> > > >
> > > > Is this possible? If so, is there any advice you can give me to help do
> > > > this? Thank you.
> > > >
> > > > Kevin Green
> > > > Software Engineer
> > > > Pragmatech Software
> > > >
> > > >
> >
> >|||That's exactly what i need, but i can't figure out how!
It also has to be secure of course.
Bruce L-C [MVP] wrote:
> Also in RS 2005 you can dynamically change the datasource based on the user.
> I haven't done this but it is one of the capabilities.
> Bruce Loehle-Conger
> "magendo_man" <magendoman@.discussions.microsoft.com> wrote in message
> news:BCD91F31-A84B-40D2-8B00-2FB36C53CD52@.microsoft.com...
> > Are the databases on two different SQL servers? How do the users run the
> > report? From Report Manager, or embedded in a web page?
> >
> > If they are running the reports from Report Manager on different servers
> > then you need to set up data sources (i.e. rds files) on each, with the
> > same
> > name, but pointing to the site-specific database.
> >
> > "KevinGreen24@.gmail.com" wrote:
> >
> >> Well we're working of a SaaS model, so every end user is running a thin
> >> client, so we're not installing anything on the end user's computer.
> >>
> >> magendo_man wrote:
> >> > On each computer have an rds file specifying the connection properties
> >> > for
> >> > that computer.
> >> >
> >> > "KevinGreen24@.gmail.com" wrote:
> >> >
> >> > > Hello all,
> >> > >
> >> > > Here's my situation:
> >> > >
> >> > > I have a single RDL file that describes a certain report.
> >> > >
> >> > > I have different databases on different computers with the same
> >> > > tables
> >> > > but different data in each table.
> >> > >
> >> > > I need people to go to each computer, run the same RDL file, but have
> >> > > it show the data that is specific to their database.
> >> > >
> >> > > For instance, there is a single .rdl file which describes a personnel
> >> > > report, and i want people at site A to only see info about site A's
> >> > > personnel, and people at site B to only see info about site B's
> >> > > personnel.
> >> > >
> >> > > Is this possible? If so, is there any advice you can give me to help
> >> > > do
> >> > > this? Thank you.
> >> > >
> >> > > Kevin Green
> >> > > Software Engineer
> >> > > Pragmatech Software
> >> > >
> >> > >
> >>
> >>|||The below is from help. Note that they show using a parameter but you could
also use the result of a query that uses the global variable for user (I
believe it is User!Username). Have a table that provides the mapping from
user to database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
>>>>>>>>
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/4d8f0ae1-102b-4b3d-9155-fa584c962c9e.htm
Data Source Expressions
Data source expressions are processed at run time or when a report is
previewed. The expression must be written in Visual Basic. Use the following
guidelines when defining a data source expression:
a.. Design the report using a static connection string. A static
connection string refers to a connection string that is not set through an
expression (for example, when you follow the steps for creating a
report-specific or shared data source, you are defining a static connection
string). Using a static connection string allows you to connect to the data
source in Report Designer so that you can get the query results you need to
create the report.
b.. When defining the data source connection, do not use a shared data
source. You cannot use a data source expression in a shared data source. You
must define a report-specific data source for the report.
c.. Specify credentials separately from the connection string. You can use
stored credentials, prompted credentials, or integrated security.
d.. Add a report parameter to specify a data source. For parameter values,
you can either provide a static list of available values (in this case, the
available values should be data sources you can use with the report) or
define a query that retrieves a list of data sources at run time.
e.. Be sure that the list of data sources share the same database schema.
All report design begins with schema information. If there is a mismatch
between the schema used to define the report and the actual schema used by
the report at run time, the report might not run.
f.. Before publishing the report, replace the static connection string
with an expression. Wait until you are finished designing the report before
you replace the static connection string with an expression. Once you use an
expression, you cannot execute the query in Report Designer. Furthermore,
the field list in the Datasets window and the Parameters list will not
update automatically.
>>>>>>>>>
<KevinGreen24@.gmail.com> wrote in message
news:1153261522.566759.269720@.h48g2000cwc.googlegroups.com...
> That's exactly what i need, but i can't figure out how!
> It also has to be secure of course.
> Bruce L-C [MVP] wrote:
>> Also in RS 2005 you can dynamically change the datasource based on the
>> user.
>> I haven't done this but it is one of the capabilities.
>> Bruce Loehle-Conger
>> "magendo_man" <magendoman@.discussions.microsoft.com> wrote in message
>> news:BCD91F31-A84B-40D2-8B00-2FB36C53CD52@.microsoft.com...
>> > Are the databases on two different SQL servers? How do the users run
>> > the
>> > report? From Report Manager, or embedded in a web page?
>> >
>> > If they are running the reports from Report Manager on different
>> > servers
>> > then you need to set up data sources (i.e. rds files) on each, with the
>> > same
>> > name, but pointing to the site-specific database.
>> >
>> > "KevinGreen24@.gmail.com" wrote:
>> >
>> >> Well we're working of a SaaS model, so every end user is running a
>> >> thin
>> >> client, so we're not installing anything on the end user's computer.
>> >>
>> >> magendo_man wrote:
>> >> > On each computer have an rds file specifying the connection
>> >> > properties
>> >> > for
>> >> > that computer.
>> >> >
>> >> > "KevinGreen24@.gmail.com" wrote:
>> >> >
>> >> > > Hello all,
>> >> > >
>> >> > > Here's my situation:
>> >> > >
>> >> > > I have a single RDL file that describes a certain report.
>> >> > >
>> >> > > I have different databases on different computers with the same
>> >> > > tables
>> >> > > but different data in each table.
>> >> > >
>> >> > > I need people to go to each computer, run the same RDL file, but
>> >> > > have
>> >> > > it show the data that is specific to their database.
>> >> > >
>> >> > > For instance, there is a single .rdl file which describes a
>> >> > > personnel
>> >> > > report, and i want people at site A to only see info about site
>> >> > > A's
>> >> > > personnel, and people at site B to only see info about site B's
>> >> > > personnel.
>> >> > >
>> >> > > Is this possible? If so, is there any advice you can give me to
>> >> > > help
>> >> > > do
>> >> > > this? Thank you.
>> >> > >
>> >> > > Kevin Green
>> >> > > Software Engineer
>> >> > > Pragmatech Software
>> >> > >
>> >> > >
>> >>
>> >>
>|||Right. That's similar what I did to solve the problem this morning:
1. Create the master .rdl file that has a hidden parameter called
"DbName"
2. Make the connection string in the data source dynamic:
="Data Source=(local);Initial Catalog=" & Parameters!DbName.Value
3. Create a linked report(s)
4. Using the report manager, set the default value of DbName according
to the company that will own each linked report.
This way, the parameter can be set for the report based on the company
it belongs to, and it's also secure because role-based security can be
set up at the linked report level.
Bruce L-C [MVP] wrote:
> The below is from help. Note that they show using a parameter but you could
> also use the result of a query that uses the global variable for user (I
> believe it is User!Username). Have a table that provides the mapping from
> user to database.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> >>>>>>>>
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/4d8f0ae1-102b-4b3d-9155-fa584c962c9e.htm
> Data Source Expressions
> Data source expressions are processed at run time or when a report is
> previewed. The expression must be written in Visual Basic. Use the following
> guidelines when defining a data source expression:
> a.. Design the report using a static connection string. A static
> connection string refers to a connection string that is not set through an
> expression (for example, when you follow the steps for creating a
> report-specific or shared data source, you are defining a static connection
> string). Using a static connection string allows you to connect to the data
> source in Report Designer so that you can get the query results you need to
> create the report.
>
> b.. When defining the data source connection, do not use a shared data
> source. You cannot use a data source expression in a shared data source. You
> must define a report-specific data source for the report.
>
> c.. Specify credentials separately from the connection string. You can use
> stored credentials, prompted credentials, or integrated security.
>
> d.. Add a report parameter to specify a data source. For parameter values,
> you can either provide a static list of available values (in this case, the
> available values should be data sources you can use with the report) or
> define a query that retrieves a list of data sources at run time.
>
> e.. Be sure that the list of data sources share the same database schema.
> All report design begins with schema information. If there is a mismatch
> between the schema used to define the report and the actual schema used by
> the report at run time, the report might not run.
>
> f.. Before publishing the report, replace the static connection string
> with an expression. Wait until you are finished designing the report before
> you replace the static connection string with an expression. Once you use an
> expression, you cannot execute the query in Report Designer. Furthermore,
> the field list in the Datasets window and the Parameters list will not
> update automatically.
> >>>>>>>>>
> <KevinGreen24@.gmail.com> wrote in message
> news:1153261522.566759.269720@.h48g2000cwc.googlegroups.com...
> > That's exactly what i need, but i can't figure out how!
> >
> > It also has to be secure of course.
> >
> > Bruce L-C [MVP] wrote:
> >> Also in RS 2005 you can dynamically change the datasource based on the
> >> user.
> >>
> >> I haven't done this but it is one of the capabilities.
> >>
> >> Bruce Loehle-Conger
> >>
> >> "magendo_man" <magendoman@.discussions.microsoft.com> wrote in message
> >> news:BCD91F31-A84B-40D2-8B00-2FB36C53CD52@.microsoft.com...
> >> > Are the databases on two different SQL servers? How do the users run
> >> > the
> >> > report? From Report Manager, or embedded in a web page?
> >> >
> >> > If they are running the reports from Report Manager on different
> >> > servers
> >> > then you need to set up data sources (i.e. rds files) on each, with the
> >> > same
> >> > name, but pointing to the site-specific database.
> >> >
> >> > "KevinGreen24@.gmail.com" wrote:
> >> >
> >> >> Well we're working of a SaaS model, so every end user is running a
> >> >> thin
> >> >> client, so we're not installing anything on the end user's computer.
> >> >>
> >> >> magendo_man wrote:
> >> >> > On each computer have an rds file specifying the connection
> >> >> > properties
> >> >> > for
> >> >> > that computer.
> >> >> >
> >> >> > "KevinGreen24@.gmail.com" wrote:
> >> >> >
> >> >> > > Hello all,
> >> >> > >
> >> >> > > Here's my situation:
> >> >> > >
> >> >> > > I have a single RDL file that describes a certain report.
> >> >> > >
> >> >> > > I have different databases on different computers with the same
> >> >> > > tables
> >> >> > > but different data in each table.
> >> >> > >
> >> >> > > I need people to go to each computer, run the same RDL file, but
> >> >> > > have
> >> >> > > it show the data that is specific to their database.
> >> >> > >
> >> >> > > For instance, there is a single .rdl file which describes a
> >> >> > > personnel
> >> >> > > report, and i want people at site A to only see info about site
> >> >> > > A's
> >> >> > > personnel, and people at site B to only see info about site B's
> >> >> > > personnel.
> >> >> > >
> >> >> > > Is this possible? If so, is there any advice you can give me to
> >> >> > > help
> >> >> > > do
> >> >> > > this? Thank you.
> >> >> > >
> >> >> > > Kevin Green
> >> >> > > Software Engineer
> >> >> > > Pragmatech Software
> >> >> > >
> >> >> > >
> >> >>
> >> >>
> >
Showing posts with label separate. Show all posts
Showing posts with label separate. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
I too, cannot connect to SQL EXPRESS via different sub-nets
I have been having a problem, each of our departments is on a separate sub net e. 165.10.xx.xx where my server exists on 165.10.10.10 other worksatations upon the same sub net can access the database, where as those on a separate sub-net e.g. 165.10.12.25 cannot.
The particular data base is a an sqlexpress database, which is accessed through an access-front end utilizing ODBC for the connectivity. The user does have access rights via windows security to both the database directory, as well as the front access specific directory. When trying to set up the ODBC driver I cannot browse to the server, I can however type it in e.g. host\sqlexpress i do get through the authentication screen utilizing windows authentication. When I try to change the database from master to the application database I get an error stating database does not exist.
I have confirmed that the sql server is listening (which seemed obvious that same sub-net could get in) I have also assured the problem sub-net workstation is not running any fire wqall blocks or port filters.
--Today I logged on to the work station as myself (system administrator) and I can set up the ODBC driver under my rights, once i typed in the server name, I could see the database I needed. This gave me the idea of adding the user in the problem sub-net to the server administrators group -- which does allow the user access.
I had thought that the secure by design paradigm shift allowed access with minimal rights.
My question is this :
How do I configure the server so that the user is not required to be an administrator on it, so that access to the data can be granted, while keeping a modicum of security on the server?
Any help would be most welcome -- Thanks ;-)
Are you successfully able to connect to the server on subnet 165.10.10.10 from different subnets after making the connecting users admins on the server machine?
It seems very odd that your network connectivity problem would be solved by adding the member to the administrators group. This is not expected and is not required. Are you using IP security in your environment? What is the precise error message that you're receiving when your connection attemp fails?
To get started on how to provision login access for non-administrator users, here's a good page: http://msdn2.microsoft.com/en-us/library/ms189751.aspx. If you look around this part of the documentation you'll find more details on the minimum set of permissions needed for users to successfully login.
Hope this helps,
Vaughn
|||Once I add the user to the Administrators group on the host machine she can connect to the database and function.
What strikes me as odd though, is that i still have to actually type in the host/sqlexpress refrence as it will not show up in the
Which server do you want to connect to?
Server -- combo box
The authentication step works
then I can see the compulsionasset database in the
Change default database to checkbox -- drop down combo
When the user is not an administrator
I still have to type the server name, authentication still works, but the database table does not show up for selection, and typing it in I get an error that it doesn't exist so that the ODBC administrator wizard will not complete.
There are no other errors.
Adding her to the administrators group did get her in though.
|||Oh...
I have given her a login for he domain account within SQLExpress on the appropriate table...
|||Once I add them as administrator they can connect. It does seem crippled though, usually page ione of the ODBC setup wizard lets you choose from a drop down combo box - the server, I must type the full name in as it doesn't see it. then Page 3 usually lets you change the default database -- as an administrator they can see the database -- if not they can only see the default databases master, tempdb and model. Both means appear to connect -- without error messages on page 2 of the wizard.
|||I'm not sure if the drop down combo box and the login problem have the same root cause but here's what I'd suggest for fixing the drop down:
1) Ensure the SQL Server instance has TCP/IP enabled (it almost certainly does since remote admin connections work)
2) Ensure the SQL Browser service is running on the server machine
3) Make sure there are no firewalls (e.g. windows firewall) blocking connectivity to the sql server instance or sqlbrowser. For SQL Browser you can either add the executable or open UDP port 1433. For the name SQLExpress instance you'll need to add the process since the TCP port is dynamic unless you've manually configured it otherwise.
4) Double check that in SQL Server Configuration Manager there's not a "HideInstance" flag set to true for the SQLExpress instance
Checking all of these *should* make the instance show up in the drop down box.
|||All of those have been checked. I can see the server from machines within the same subnet, I cannot from machines on a different subnet. Though those users can browse the host via windows networking., there are other instances that do not show up within the drop down as well, though, again they do when on the same subnet.
All firewalls are external to the network none between subnets.
Again, thanks for any and all help.
I too, cannot connect to SQL EXPRESS via different sub-nets
I have been having a problem, each of our departments is on a separate sub net e. 165.10.xx.xx where my server exists on 165.10.10.10 other worksatations upon the same sub net can access the database, where as those on a separate sub-net e.g. 165.10.12.25 cannot.
The particular data base is a an sqlexpress database, which is accessed through an access-front end utilizing ODBC for the connectivity. The user does have access rights via windows security to both the database directory, as well as the front access specific directory. When trying to set up the ODBC driver I cannot browse to the server, I can however type it in e.g. host\sqlexpress i do get through the authentication screen utilizing windows authentication. When I try to change the database from master to the application database I get an error stating database does not exist.
I have confirmed that the sql server is listening (which seemed obvious that same sub-net could get in) I have also assured the problem sub-net workstation is not running any fire wqall blocks or port filters.
--Today I logged on to the work station as myself (system administrator) and I can set up the ODBC driver under my rights, once i typed in the server name, I could see the database I needed. This gave me the idea of adding the user in the problem sub-net to the server administrators group -- which does allow the user access.
I had thought that the secure by design paradigm shift allowed access with minimal rights.
My question is this :
How do I configure the server so that the user is not required to be an administrator on it, so that access to the data can be granted, while keeping a modicum of security on the server?
Any help would be most welcome -- Thanks ;-)
Are you successfully able to connect to the server on subnet 165.10.10.10 from different subnets after making the connecting users admins on the server machine?
It seems very odd that your network connectivity problem would be solved by adding the member to the administrators group. This is not expected and is not required. Are you using IP security in your environment? What is the precise error message that you're receiving when your connection attemp fails?
To get started on how to provision login access for non-administrator users, here's a good page: http://msdn2.microsoft.com/en-us/library/ms189751.aspx. If you look around this part of the documentation you'll find more details on the minimum set of permissions needed for users to successfully login.
Hope this helps,
Vaughn
|||Once I add the user to the Administrators group on the host machine she can connect to the database and function.
What strikes me as odd though, is that i still have to actually type in the host/sqlexpress refrence as it will not show up in the
Which server do you want to connect to?
Server -- combo box
The authentication step works
then I can see the compulsionasset database in the
Change default database to checkbox -- drop down combo
When the user is not an administrator
I still have to type the server name, authentication still works, but the database table does not show up for selection, and typing it in I get an error that it doesn't exist so that the ODBC administrator wizard will not complete.
There are no other errors.
Adding her to the administrators group did get her in though.
|||Oh...
I have given her a login for he domain account within SQLExpress on the appropriate table...
|||Once I add them as administrator they can connect. It does seem crippled though, usually page ione of the ODBC setup wizard lets you choose from a drop down combo box - the server, I must type the full name in as it doesn't see it. then Page 3 usually lets you change the default database -- as an administrator they can see the database -- if not they can only see the default databases master, tempdb and model. Both means appear to connect -- without error messages on page 2 of the wizard.
|||I'm not sure if the drop down combo box and the login problem have the same root cause but here's what I'd suggest for fixing the drop down:
1) Ensure the SQL Server instance has TCP/IP enabled (it almost certainly does since remote admin connections work)
2) Ensure the SQL Browser service is running on the server machine
3) Make sure there are no firewalls (e.g. windows firewall) blocking connectivity to the sql server instance or sqlbrowser. For SQL Browser you can either add the executable or open UDP port 1433. For the name SQLExpress instance you'll need to add the process since the TCP port is dynamic unless you've manually configured it otherwise.
4) Double check that in SQL Server Configuration Manager there's not a "HideInstance" flag set to true for the SQLExpress instance
Checking all of these *should* make the instance show up in the drop down box.
|||All of those have been checked. I can see the server from machines within the same subnet, I cannot from machines on a different subnet. Though those users can browse the host via windows networking., there are other instances that do not show up within the drop down as well, though, again they do when on the same subnet.
All firewalls are external to the network none between subnets.
Again, thanks for any and all help.
Subscribe to:
Posts (Atom)