Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our firewall. Our Custom opened the Port #1433 for us. We also open the port on our side. However, we stil can not connect. We got "SQL Server Does Not Exist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues. (Our side or our custom side)....
Lisa
Are you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;Data Source=123.456.78.90;
Anything wrong? THANKS?
|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connections string as well...
|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
sql

Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our
firewall. Our Custom opened the Port #1433 for us. We also open the port o
n our side. However, we stil can not connect. We got "SQL Server Does Not E
xist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues.
(Our side or our custom side)....
LisaAre you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;
Data Source=123.456.78.90;
Anything wrong? THANKS?|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connect
ions string as well...|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can move a file outside of PRIMARY to a new file group?

So I messed up and didn't create file groups for my scheme
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
Erik
No, that is because SQL Server don't place objects on a certain file, it places objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects, shrink the original file
using (EMPTYFILE) and then drop that file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegr oups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>

Can move a file outside of PRIMARY to a new file group?

So I messed up and didn't create file groups for my scheme
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
ErikNo, that is because SQL Server don't place objects on a certain file, it pla
ces objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects,
shrink the original file
using (EMPTYFILE) and then drop that file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegroups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>

Can move a file outside of PRIMARY to a new file group?

So I messed up and didn't create file groups for my scheme
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
ErikNo, that is because SQL Server don't place objects on a certain file, it places objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects, shrink the original file
using (EMPTYFILE) and then drop that file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegroups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>

can i process cube from outside analysis manager

I need to process a cube, but i want to do it using c#.. is there any way? Or any example with anyoneThere are a number of ways to process a cube from outside the manager, two come to mind:
1) Use the process cube task in Integration Services.
2) Write a .net program that does it using Analysis Managment Objects (replacement for 2000's DSO objects).

For more options and documentation visit: http://msdn2.microsoft.com/en-us/library/ms243781