SYSADMIN

(Home)

Join a Windows 2003 Server Domain

ie

Corporate1.TestCo.Local   is the server name.

connect to domain using

Administrator and Password    not Admin@... and password

use TestCo.Local for domain name.

XP - Start/All Programs/Accessories/Communication/Remote Desktop Connection

In computer name type the External IP! Thereafter type the name of the computer if you like!

Expand the options button!!!

Computer: {External IP}   Example: (68.19.111.10)

Username: Domain user name or local user name with administration security!

Password: User's password

Domain: What does the router see? A domain and or a local server or client!

Domain Name or Computer Name

Add user to Terminal Services Configuration!

You can only have two users here because of license restrictions!

Buy licensing if you need more than two people!

TERMINAL SERVICES

Terminal Service Setup:    Two Choices

Remote Administration Mode - 2 users can access system at any one time! This does not include the administrator! 

Application Server Mode  - You have 90 days to buy licensing!

Select Start/All Programs/Administrator Tools/Terminal Services Configuration

Select the permissions tab!

Add user!

You do not have to add a user here if they have local administrator rights!

And you want to restrict them to just that 1 box!

To start the Scheduled Task Wizard - double-click Add Scheduled Task. In the resulting screen, which provides a short description of the Scheduled Task Wizard, click Next to bring up the screen that lets you select the Windows application you want to schedule. If you want to run an application that isn't listed, click Browse and find the executable of the application you want to schedule a task for.

After you've chosen an application, click Next. The application name will appear as the task name on the next screen. Pick the time scenario in which you want the application to run and click Next. Select the specific time and date to run the desired task. (During this step check whether your system clock is correct or not.) Click Next. The system will present you with the message Enter the name and password of a user. The task will run as if it were started by that user. Make sure that you use the same username and password that you used when you logged on!!!

The ASE .NET Data Provider is an add-on component to the .NET 1.1 Framework that allows you to access a Sybase Adaptive Server Enterprise (ASE) database. 

Using C# using Sybase.Data.AseClient; ... 

AseConnection oAseConn = new AseConnection(); oAseConn.ConnectionString = "Data Source=(local);" + "Initial Catalog=myDatabaseName;" + "User ID=myUsername;" + "Password=myPassword" oAseConn.Open(); 

Using VB.NET Imports System.Data.AseClient ... 

Dim oAseConn As AseConnection = New AseConnection() oAseConn.ConnectionString = "Data Source=(local);" & _ "Initial Catalog=myDatabaseName;" & _ "User ID=myUsername;" & _ "Password=myPassword" oAseConn.Open() 

For more information, see: ASE User's Guide -------------------------------------------------------------------------------- MySQLDirect .NET Data Provider CoreLab.MySql 

The MySQLDirect .NET Data Provider is an add-on component to the .NET Framework that allows you to access the MySQL database using native MySQL network protocol or MySQL client, without going through OLE DB or ODBC. 

Using C# using CoreLab.MySql; 

MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = "User ID=myUsername;" + "Password=myPassword;" + "Host=localhost;" + "Port=3306;" + "Database=myDatabaseName;" + "Direct=true;" + "Protocol=TCP;" + "Compress=false;" + "Pooling=true;" + "Min Pool Size=0;" + "Max Pool Size=100;" + "Connection Lifetime=0"; oMySqlConn.Open(); 

Using VB.NET Imports CoreLab.MySql 

Dim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = "User ID=myUsername;" & _ "Password=myPassword;" & _ "Host=localhost;" & _ "Port=3306;" & _ "Database=myDatabaseName;" & _ "Direct=true;" & _ "Protocol=TCP;" & _ "Compress=false;" & _ "Pooling=true;" & _ "Min Pool Size=0;" & _ "Max Pool Size=100;" & _ "Connection Lifetime=0" oMySqlConn.Open() 

For more information, see: CoreLab's MySqlDirect .NET Data Provider -------------------------------------------------------------------------------- ODBC .NET Data Provider System.Data.ODBC 

The Open Database Connectivity (ODBC) .NET Data Provider is an add-on component to the .NET Framework.

 It provides access to native ODBC drivers the same way the OLE DB .NET Data Provider provides access to native OLE DB providers. Note: This technology is included in version 1.1 of the .NET Framework. You need only download this, if you are running version 1.0. 

For SQL Server ODBC Driver ' VB.NET Imports System.Data.Odbc ... 

Dim oODBCConnection As OdbcConnection Dim sConnString As String = _ "Driver={SQL Server};" & _ "Server=MySQLServerName;" & _ "Database=MyDatabaseName;" & _ "Uid=MyUsername;" & _ "Pwd=MyPassword" oODBCConnection = New Odbc.OdbcConnection(sConnString) oODBCConnection.Open() 

For Oracle ODBC Driver ' VB.NET Imports System.Data.Odbc ... 

Dim oODBCConnection As OdbcConnection Dim sConnString As String = _ "Driver={Microsoft ODBC for Oracle};" & _ "Server=OracleServer.world;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" oODBCConnection = New Odbc.OdbcConnection(sConnString) oODBCConnection.Open() 

For Access (JET) ODBC Driver ' VB.NET Imports System.Data.Odbc ... 

Dim oODBCConnection As OdbcConnection Dim sConnString As String = _ "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=c:\somepath\mydb.mdb;" & _ "Uid=Admin;" & _ "Pwd=" oODBCConnection = New Odbc.OdbcConnection(sConnString) oODBCConnection.Open() 

For Sybase System 11 ODBC Driver ' VB.NET Imports System.Data.Odbc ... 

Dim oODBCConnection As OdbcConnection Dim sConnString As String = _ "Driver={Sybase System 11};" & _ "SRVR=mySybaseServerName;" & _ "DB=myDatabaseName;" & _ "UID=myUsername;" & _ "PWD=myPassword" oODBCConnection = New OdbcConnection(sConnString) oODBCConnection.Open() 

For all other ODBC Drivers ' VB.NET Imports System.Data.Odbc ... 

Dim oODBCConnection As OdbcConnection Dim sConnString As String = "Dsn=myDsn;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" oODBCConnection = New Odbc.OdbcConnection(sConnString) oODBCConnection.Open() 

For more information, see: OdbcConnection Class and .NET Data Providers To view Microsoft KB articles related to OdbcConnection, click here -------------------------------------------------------------------------------- OLE DB .NET Data Provider System.Data.OleDb 

The Microsoft .NET Framework Data Provider for OLE DB allow you to use native OLE DB providers (e.g. Microsoft.JET.OLEDB.4.0) through COM interop to enable data access. 

The Microsoft .NET Framework Data Provider for OLE DB is included in both the 1.0 and 1.1 version of the .NET Framework. For IBM AS/400 OLE DB Provider ' VB.NET Imports System.Data.OleDb ... 

Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=IBMDA400.DataSource.1;" & _ "Data source=myAS400DbName;" & _ "User Id=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 

For JET OLE DB Provider ' VB.NET Imports System.Data.OleDb ... 

Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\myPath\myJet.mdb;" & _ "User ID=Admin;" & _ "Password=" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 

For Oracle OLE DB Provider ' VB.NET Imports System.Data.OleDb ... 

Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _ "User ID=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 

For SQL Server OLE DB Provider ' VB.NET Imports System.Data.OleDb ... 

Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "User Id=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 

For Sybase ASE OLE DB Provider ' VB.NET Imports System.Data.OleDb ... 

Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=Sybase ASE OLE DB Provider;" & _ "Data Source=MyDataSourceName;" & _ "Server Name=MyServerName;" & _ "Database=MyDatabaseName;" & _ "User ID=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 

For more information, see: OleDbConnection Class and .NET Data Providers To view Microsoft KB articles related to OleDbConnection, click here -------------------------------------------------------------------------------- Oracle .NET Data Provider - From Microsoft System.Data.OracleClient The Microsoft .NET Framework Data Provider for Oracle is an add-on component to the .NET Framework 1.0 that provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. 

Oracle 8i Release 3 (8.1.7) Client or later must be installed for this provider to function correctly. Note: This .NET Data Provider is included in version 1.1 of the .NET Framework. You need only download this, if you are running version 1.0. 

Using C#: using System.Data.OracleClient; 

OracleConnection oOracleConn = new OracleConnection(); oOracleConn.ConnectionString = "Data Source=Oracle8i;" + "Integrated Security=SSPI"; oOracleConn.Open(); 

Using VB.NET: Imports System.Data.OracleClient 

Dim oOracleConn As OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "Data Source=Oracle8i;" & _ "Integrated Security=SSPI"; oOracleConn.Open() 

For more information, see: OracleConnection Class and .NET Data Providers To view Microsoft KB articles related to OracleConnection, click here -------------------------------------------------------------------------------- Oracle .NET Data Provider - From Oracle Oracle.DataAccess.Client The Oracle .NET Framework Data Provider from Oracle is an add-on component to the .NET Framework. 

Using C# using Oracle.DataAccess.Client; ... 

OracleConnection oOracleConn = new OracleConnection(); oOracleConn.ConnectionString = "Data Source=MyOracleServerName;" + "Integrated Security=SSPI"; oOracleConn.Open(); 

Using VB.NET Imports Oracle.DataAccess.Client ... 

Dim oOracleConn As OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "Data Source=MyOracleServerName;" & _ "Integrated Security=SSPI"; oOracleConn.Open() 

For more information, see: Oracle Data Provider for .NET -------------------------------------------------------------------------------- OraDirect .NET Data Provider - From CoreLab CoreLab.

Oracle The OraDirect .NET Data Provider is an add-on component to the .NET Framework that provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. 

Using C# using CoreLab.Oracle; 

OracleConnection oOracleConn = new OracleConnection(); oOracleConn.ConnectionString = "User ID=myUsername;" + "Password=myPassword;" + "Host=(local);" + "Pooling=true;" + "Min Pool Size=0;" + "Max Pool Size=100;" + "Connection Lifetime=0"; oOracleConn.Open(); 

Using VB.NET Imports CoreLab.Oracle 

Dim oOracleConn As OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "User ID=myUsername;" & _ "Password=myPassword;" & _ "Host=(local);" & _ "Pooling=true;" & _ "Min Pool Size=0;" & _ "Max Pool Size=100;" & _ "Connection Lifetime=0" oOracleConn.Open() 

For more information, see: OraDirect .NET Data Provider -------------------------------------------------------------------------------- MySQL .NET Data Provider EID.MySqlClient  

The MySQL .NET Native Provider is an add-on component to the .NET Framework that allows you to access the MySQL database through the native protocol, without going through OLE DB or ODBC. 

Using C# using EID.MySqlClient; ... 

MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = "Data Source=(local);" + "Database=myDatabaseName;" + "User ID=myUsername;" + "Password=myPassword;" + "Command Logging=false"; oMySqlConn.Open(); 

Using VB.NET Imports EID.MySqlClient ... 

Dim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = "Data Source=(local);" & _ "Database=myDatabaseName;" & _ "User ID=myUsername;" & _ "Password=myPassword;" & _ "Command Logging=false" oMySqlConn.Open() 

For more information, see: EID's MySQL ADO.NET native provider -------------------------------------------------------------------------------- PostgreSQLDirect .NET Data Provider CoreLab.PostgreSql 

The PostgreSQLDirect .NET Data Provider is an add-on component to the .NET Framework that allows you to access the PostgreSQL database using native message-based protocol, without going through OLE DB or ODBC. 

Using C# using CoreLab.PostgreSql; 

PgSqlConnection oPgSqlConn = new PgSqlConnection(); oPgSqlConn.ConnectionString = "User ID=myUsername;" + "Password=myPassword;" + "Host=localhost;" + "Port=5432;" + "Database=myDatabaseName;" + "Pooling=true;" + "Min Pool Size=0;" + "Max Pool Size=100;" + "Connection Lifetime=0"; oPgSqlConn.Open(); 

Using VB.NET Imports CoreLab.PostgreSql 

Dim oPgSqlConn As PgSqlConnection = New PgSqlConnection() oPgSqlConn.ConnectionString = "User ID=myUsername;" & _ "Password=myPassword;" & _ "Host=localhost;" & _ "Port=5432;" & _ "Database=myDatabaseName;" & _ "Pooling=true;" & _ "Min Pool Size=0;" & _ "Max Pool Size=100;" & _ "Connection Lifetime=0" oPgSqlConn.Open() 

For more information, see: PostgreSQLDirect .NET Data Provider -------------------------------------------------------------------------------- SQL Server .NET Data Provider System.Data.SqlClient 

The SQL Server .NET Data Provide allows you to connect to a Microsoft SQL Server 7.0 or 2000 database. For Microsoft SQL Server 6.5 or earlier, use the OLE DB .NET Data Provider with the "SQL Server OLE DB Provider" (SQLOLEDB). Note: The SQL Server .NET Data Provider knows which data provider it is. Hence the "provider=" part of the connection string is not needed. 

Using C#: using System.Data.SqlClient; ... 

SqlConnection oSQLConn = new SqlConnection(); oSQLConn.ConnectionString = "Data Source=(local);" + "Initial Catalog=myDatabaseName;" + "Integrated Security=SSPI"; oSQLConn.Open(); 

Using VB.NET: Imports System.Data.SqlClient ... 

Dim oSQLConn As SqlConnection = New SqlConnection() oSQLConn.ConnectionString = "Data Source=(local);" & _ "Initial Catalog=myDatabaseName;" & _ "Integrated Security=SSPI" oSQLConn.Open() If connection to a remote server (via IP address): oSQLConn.ConnectionString = "Network Library=DBMSSOCN;" & _ "Data Source=xxx.xxx.xxx.xxx,1433;" & _ "Initial Catalog=myDatabaseName;" & _ "User ID=myUsername;" & _ "Pas sword=myPassword" Where: - "Network Library=DBMSSOCN" tells SqlConnection to use TCP/IP Q238949 - xxx.xxx.xxx.xxx is an IP address. - 1433 is the default port number for SQL Server. Q269882 and Q287932 - You can also add "Encrypt=yes" for encryption 

For more information, see: SqlConnection Class, Q308656, and .NET Data Providers Note: Microsoft SQLXML Managed Classes exposes the functionality of SQLXML inside the Microsoft .NET Framework. To view Microsoft KB articles related to SQLClient, click here

Run Setup.exe

Automatically configures firewall.

Add An AXIS  printer

Wmlpc203 is the AXIS PRINT SERVER!!!

Configure the WMLPC203 first and then point to this pc from all of the pc’s!!!

To configure WMLPC203:

See current configured printers ie I-036.   c_rp_4.

First configured line printer for requisitions!

Plug from cat board port to printer switch at bottom portion of rack!!!

Plug rj45 cable from wall port to axis print server on printer!

*****************************************************************

***AXIS print server(the one going on the printer itself)

      needs to be configured on the correct SUBNET!!!!!

      Manny has a box to do this(typically a pc that has the axis server management                                         

ARP DOS COMMAND

Example:

arp [-switch] [ip address] [mac address/serial number]

Arp –s 172.16.200.61 00-40-5C-8E-81

BROWSER

Goto ip address of axis print server.

ie http://172.16.200.61

configure the tcpip to sub net!

Match existing pages the sub net ends in 254

Double click on the axis print server test button on the axis print servers on the printers!!!

This will validate that the ip’s have taken!!!

Ping  ip address

If ok then

ADD PORT TO CLIENT PC!!!

No axis port will be available on any pc that does not have axis servser software!

Chose LPR  line printer

Put ip address in

Name = LP   for line printer

Add 4 ports to client

172.16.200.61LP

172.16.200.62LP

172.16.200.63LP

172.16.200.64LP

NT CONFIGURATION

POINT TO REQ PRINT SERVER

Settings

Add printer

Use TCP/IP to configure and point to network printer!

WMLPC203

Select manage

The Computer Management Console comes up!

Select local users and groups!

Snap ins will not be found on domain controllers!

This must be a member server!

Add new TCP/IP port after adding printer. From Add/Edit/Remove Ports!

Always be sure that the ip's are reversed from local group/remote group on both pc's.

Be sure to use subnet for ip addresses ending in 0. And ip address for addresses ending with a number greater than 0.

***************************************

BLOCKED TCP/IP PACKETS

***************************************

Firewalls can stop traffic!

POP UP Blockers can stop traffic!

Browser problems!