Connections through a server alias, IP address, or any other alternate name are not supported.

SQL Server Replication

Index ‹ SQL Server
- Archive
  - VS Express
  - Dotnet
  - VS 2008
  - IE
  - VB
  - ISV
  - Windows Forms
  - Smart Device
  - Architecture
  - SharePoint
  - Windows Vista
  - VFP
  - SQL Server
  - Visual C#
  - Visual Studio
  - Windows Live
  - Game
  - Office
  - VC++

- Previous
 - 1
 - SUM returns incorrect value in SQL Server Mobile Query ... Bug?? This might be a bug in our code. I have trouble reproducing the problem. Can you share the database (or just the schema) so that I can take a look. Thanks Pragya Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 2
 - Blocking in Analysis Services We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 3
 - converting varchar to int It is clearly an SQL error which cannot be solved in SSRS using expressions. I'm assuming that your dataset is formed by a stored procedure, not plain SQL text. The error is because you are trying to put an invalid integer value into a table (temporary table or user table) column which is of INT datatype. If possible, get the SQL text of the stored procedure and check all insert/update statements and all the columns of INT datatype involved in it. Also check If there is an implicit conversion using CONVERT or CAST function. Shyam Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 4
 - Error - The report server cannot decrypt the symmetric key? Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions 每 by default this is only username & password in File Share delivery extension. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 5
 - need to determine which db is pricipal hey i did the following....Srv 1 was principal and Srv 2 was mirror....i just stopped sql services in principal and it immediately failed over to mirror coz i was having witness server......now the original principal became new mirror and original mirror became new principal...again inorder to revert back to original state i went to the db properties of the new principal and clicked failover ......immediately the new mirror reverted to original principal and new principal became original mirror........the same can also be done using T-SQL statements......sounds cool......... Alter database DBName set partner failover run it you'll get it......... Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 6
 - Different ways to set DATEFIRST This thread may help with your pursuit. You 'hould' understand the implications. Every built-in function or procedure that has anything to do with WeekDay calculations or determinations will be affected, including week of year. Obviously, day of week determiniations, and most other datetime functions 'should NOT' be adversely affected. BUT test, test, test. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 7
 - custom url not recognized i have this action.jumpto url = "javascript:void window.open('http://bklc-crm01:5555/cs/cases/edit.aspx id={" & cstr(Fields!incidentid.Value) & "}','_self')" for some reason when i use this field (incidentid.value) there is no hyperlink generated, however when i change the value to another field, the hyperlink works, what shall i be looking for, incident value is a set of number with dashes! Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 8
 - Only able to access Report Manager as Administrator There are three types of Authentification in Reporting Services: 1) Integrated Windows Authentification (Active Directory aware) is the default authentification method for the Report Server and Report Manager virtual directories. 2) Anonymous access (only suggested if used with security extensions). Anonymous access limites your ability to vary role assignment because all users will access the Report Server under the Anonymous user account. 3) Basic Authentification, which should only be used with a Secure Sockets Layer (SSL) connection because Basic Authentification sends username and passwords to the server in clear text, which could be picked up with a network sniffer. The Integrated Windows Authentification method is preferred and widely used. Your network administrator can setup Active Directory groups on the Domain Controller, which you can then grant those groups access to Reporting Services. If you network users have Unix, Mac, Novell or Linux accounts (non-Windows accounts) then you will need to go with Forms Authentification. Forms Authentification directs a request from an unauthenticated user to an HTML form, where they are prompted to enter a username and password. I have not used this method but many in this forum have and a quick search of the forum should return several useful posts. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 9
 - SQL Agent Roles IF the SQLAgent is not a part of sysadmin and that job is created by SA or any other login with SYSADMIN privileges then that login may not be able to modify the job as it is owned by SA. As referred in the article try to set the login under that role. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 10
 - error for sending(saving) data to database Form1.designer.cs namespace student { partial class Form1 { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel. IContainer components = null ; /// <summary> /// Clean up any resources being used. /// </summary> /// <param name="disposing"> true if managed resources should be disposed; otherwise, false. </param> protected override void Dispose( bool disposing) { if (disposing && (components != null )) { components.Dispose(); } base .Dispose(disposing); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this .components = new System.ComponentModel. Container (); System.ComponentModel. ComponentResourceManager resources = new System.ComponentModel. ComponentResourceManager ( typeof ( Form1 )); System.Windows.Forms. Label s_IDLabel; System.Windows.Forms. Label s_NAMELabel; System.Windows.Forms. Label s_ADDRESSLabel; System.Windows.Forms. Label s_PHONELabel; this .studentDataSet = new student. studentDataSet (); this .sTUDENTBindingSource = new System.Windows.Forms. BindingSource ( this .components); this .sTUDENTTableAdapter = new student.studentDataSetTableAdapters. STUDENTTableAdapter (); this .sTUDENTBindingNavigator = new System.Windows.Forms. BindingNavigator ( this .components); this .bindingNavigatorMoveFirstItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorMovePreviousItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorSeparator = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorPositionItem = new System.Windows.Forms. ToolStripTextBox (); this .bindingNavigatorCountItem = new System.Windows.Forms. ToolStripLabel (); this .bindingNavigatorSeparator1 = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorMoveNextItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorMoveLastItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorSeparator2 = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorAddNewItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorDeleteItem = new System.Windows.Forms. ToolStripButton (); this .sTUDENTBindingNavigatorSaveItem = new System.Windows.Forms. ToolStripButton (); this .s_IDTextBox = new System.Windows.Forms. TextBox (); this .s_NAMETextBox = new System.Windows.Forms. TextBox (); this .s_ADDRESSTextBox = new System.Windows.Forms. TextBox (); this .s_PHONETextBox = new System.Windows.Forms. TextBox (); this .sqlConnection1 = new System.Data.SqlClient. SqlConnection (); this .sqlCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlSelectCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlInsertCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlDataAdapter1 = new System.Data.SqlClient. SqlDataAdapter (); s_IDLabel = new System.Windows.Forms. Label (); s_NAMELabel = new System.Windows.Forms. Label (); s_ADDRESSLabel = new System.Windows.Forms. Label (); s_PHONELabel = new System.Windows.Forms. Label (); ((System.ComponentModel. ISupportInitialize )( this .studentDataSet)).BeginInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingSource)).BeginInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingNavigator)).BeginInit(); this .sTUDENTBindingNavigator.SuspendLayout(); this .SuspendLayout(); // // studentDataSet // this .studentDataSet.DataSetName = "studentDataSet" ; this .studentDataSet.SchemaSerializationMode = System.Data. SchemaSerializationMode .IncludeSchema; // // sTUDENTBindingSource // this .sTUDENTBindingSource.DataMember = "STUDENT" ; this .sTUDENTBindingSource.DataSource = this .studentDataSet; // // sTUDENTTableAdapter // this .sTUDENTTableAdapter.ClearBeforeFill = true ; // // sTUDENTBindingNavigator // this .sTUDENTBindingNavigator.AddNewItem = this .bindingNavigatorAddNewItem; this .sTUDENTBindingNavigator.BindingSource = this .sTUDENTBindingSource; this .sTUDENTBindingNavigator.CountItem = this .bindingNavigatorCountItem; this .sTUDENTBindingNavigator.DeleteItem = this .bindingNavigatorDeleteItem; this .sTUDENTBindingNavigator.Items.AddRange( new System.Windows.Forms. ToolStripItem [] { this .bindingNavigatorMoveFirstItem, this .bindingNavigatorMovePreviousItem, this .bindingNavigatorSeparator, this .bindingNavigatorPositionItem, this .bindingNavigatorCountItem, this .bindingNavigatorSeparator1, this .bindingNavigatorMoveNextItem, this .bindingNavigatorMoveLastItem, this .bindingNavigatorSeparator2, this .bindingNavigatorAddNewItem, this .bindingNavigatorDeleteItem, this .sTUDENTBindingNavigatorSaveItem}); this .sTUDENTBindingNavigator.Location = new System.Drawing. Point (0, 0); this .sTUDENTBindingNavigator.MoveFirstItem = this .bindingNavigatorMoveFirstItem; this .sTUDENTBindingNavigator.MoveLastItem = this .bindingNavigatorMoveLastItem; this .sTUDENTBindingNavigator.MoveNextItem = this .bindingNavigatorMoveNextItem; this .sTUDENTBindingNavigator.MovePreviousItem = this .bindingNavigatorMovePreviousItem; this .sTUDENTBindingNavigator.Name = "sTUDENTBindingNavigator" ; this .sTUDENTBindingNavigator.PositionItem = this .bindingNavigatorPositionItem; this .sTUDENTBindingNavigator.Size = new System.Drawing. Size (463, 25); this .sTUDENTBindingNavigator.TabIndex = 0; this .sTUDENTBindingNavigator.Text = "bindingNavigator1" ; // // bindingNavigatorMoveFirstItem // this .bindingNavigatorMoveFirstItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveFirstItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveFirstItem.Image" ))); this .bindingNavigatorMoveFirstItem.Name = "bindingNavigatorMoveFirstItem" ; this .bindingNavigatorMoveFirstItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveFirstItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveFirstItem.Text = "Move first" ; // // bindingNavigatorMovePreviousItem // this .bindingNavigatorMovePreviousItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMovePreviousItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMovePreviousItem.Image" ))); this .bindingNavigatorMovePreviousItem.Name = "bindingNavigatorMovePreviousItem" ; this .bindingNavigatorMovePreviousItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMovePreviousItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMovePreviousItem.Text = "Move previous" ; // // bindingNavigatorSeparator // this .bindingNavigatorSeparator.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorPositionItem // this .bindingNavigatorPositionItem.AccessibleName = "Position" ; this .bindingNavigatorPositionItem.AutoSize = false ; this .bindingNavigatorPositionItem.Name = "bindingNavigatorPositionItem" ; this .bindingNavigatorPositionItem.Size = new System.Drawing. Size (50, 21); this .bindingNavigatorPositionItem.Text = "0" ; this .bindingNavigatorPositionItem.ToolTipText = "Current position" ; // // bindingNavigatorCountItem // this .bindingNavigatorCountItem.Name = "bindingNavigatorCountItem" ; this .bindingNavigatorCountItem.Size = new System.Drawing. Size (36, 22); this .bindingNavigatorCountItem.Text = "of {0}" ; this .bindingNavigatorCountItem.ToolTipText = "Total number of items" ; // // bindingNavigatorSeparator1 // this .bindingNavigatorSeparator1.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator1.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorMoveNextItem // this .bindingNavigatorMoveNextItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveNextItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveNextItem.Image" ))); this .bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem" ; this .bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveNextItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveNextItem.Text = "Move next" ; // // bindingNavigatorMoveLastItem // this .bindingNavigatorMoveLastItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveLastItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveLastItem.Image" ))); this .bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem" ; this .bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveLastItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveLastItem.Text = "Move last" ; // // bindingNavigatorSeparator2 // this .bindingNavigatorSeparator2.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator2.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorAddNewItem // this .bindingNavigatorAddNewItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorAddNewItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorAddNewItem.Image" ))); this .bindingNavigatorAddNewItem.Name = "bindingNavigatorAddNewItem" ; this .bindingNavigatorAddNewItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorAddNewItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorAddNewItem.Text = "Add new" ; // // bindingNavigatorDeleteItem // this .bindingNavigatorDeleteItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorDeleteItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorDeleteItem.Image" ))); this .bindingNavigatorDeleteItem.Name = "bindingNavigatorDeleteItem" ; this .bindingNavigatorDeleteItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorDeleteItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorDeleteItem.Text = "Delete" ; // // sTUDENTBindingNavigatorSaveItem // this .sTUDENTBindingNavigatorSaveItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .sTUDENTBindingNavigatorSaveItem.Image = ((System.Drawing. Image )(resources.GetObject( "sTUDENTBindingNavigatorSaveItem.Image" ))); this .sTUDENTBindingNavigatorSaveItem.Name = "sTUDENTBindingNavigatorSaveItem" ; this .sTUDENTBindingNavigatorSaveItem.Size = new System.Drawing. Size (23, 22); this .sTUDENTBindingNavigatorSaveItem.Text = "Save Data" ; this .sTUDENTBindingNavigatorSaveItem.Click += new System. EventHandler ( this .sTUDENTBindingNavigatorSaveItem_Click); // // s_IDLabel // s_IDLabel.AutoSize = true ; s_IDLabel.Location = new System.Drawing. Point (44, 52); s_IDLabel.Name = "s_IDLabel" ; s_IDLabel.Size = new System.Drawing. Size (31, 13); s_IDLabel.TabIndex = 1; s_IDLabel.Text = "S ID:" ; // // s_IDTextBox // this .s_IDTextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_ID" , true )); this .s_IDTextBox.Location = new System.Drawing. Point (81, 49); this .s_IDTextBox.Name = "s_IDTextBox" ; this .s_IDTextBox.Size = new System.Drawing. Size (100, 20); this .s_IDTextBox.TabIndex = 2; // // s_NAMELabel // s_NAMELabel.AutoSize = true ; s_NAMELabel.Location = new System.Drawing. Point (51, 91); s_NAMELabel.Name = "s_NAMELabel" ; s_NAMELabel.Size = new System.Drawing. Size (51, 13); s_NAMELabel.TabIndex = 3; s_NAMELabel.Text = "S NAME:" ; // // s_NAMETextBox // this .s_NAMETextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_NAME" , true )); this .s_NAMETextBox.Location = new System.Drawing. Point (108, 88); this .s_NAMETextBox.Name = "s_NAMETextBox" ; this .s_NAMETextBox.Size = new System.Drawing. Size (100, 20); this .s_NAMETextBox.TabIndex = 4; // // s_ADDRESSLabel // s_ADDRESSLabel.AutoSize = true ; s_ADDRESSLabel.Location = new System.Drawing. Point (49, 122); s_ADDRESSLabel.Name = "s_ADDRESSLabel" ; s_ADDRESSLabel.Size = new System.Drawing. Size (72, 13); s_ADDRESSLabel.TabIndex = 5; s_ADDRESSLabel.Text = "S ADDRESS:" ; // // s_ADDRESSTextBox // this .s_ADDRESSTextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_ADDRESS" , true )); this .s_ADDRESSTextBox.Location = new System.Drawing. Point (127, 119); this .s_ADDRESSTextBox.Name = "s_ADDRESSTextBox" ; this .s_ADDRESSTextBox.Size = new System.Drawing. Size (100, 20); this .s_ADDRESSTextBox.TabIndex = 6; // // s_PHONELabel // s_PHONELabel.AutoSize = true ; s_PHONELabel.Location = new System.Drawing. Point (77, 160); s_PHONELabel.Name = "s_PHONELabel" ; s_PHONELabel.Size = new System.Drawing. Size (58, 13); s_PHONELabel.TabIndex = 7; s_PHONELabel.Text = "S PHONE:" ; // // s_PHONETextBox // this .s_PHONETextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_PHONE" , true )); this .s_PHONETextBox.Location = new System.Drawing. Point (141, 157); this .s_PHONETextBox.Name = "s_PHONETextBox" ; this .s_PHONETextBox.Size = new System.Drawing. Size (100, 20); this .s_PHONETextBox.TabIndex = 8; // // sqlConnection1 // this .sqlConnection1.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\Documents and Settings\\Glad\\Desktop" + "\\student\\student\\student.mdf\";Integrated Security=True;User Instance=True" ; this .sqlConnection1.FireInfoMessageEventOnUserErrors = true ; this .sqlConnection1.StatisticsEnabled = true ; // // sqlCommand1 // this .sqlCommand1.Parameters.AddRange( new System.Data.SqlClient. SqlParameter [] { new System.Data.SqlClient. SqlParameter ( "@S_ID" , System.Data. SqlDbType .Int, 0, System.Data. ParameterDirection .Output, false , (( byte )(0)), (( byte )(0)), "" , System.Data. DataRowVersion .Current, null ), new System.Data.SqlClient. SqlParameter ( "@S_NAME" , System.Data. SqlDbType .VarChar), new System.Data.SqlClient. SqlParameter ( "@S_ADDRESS" , System.Data. SqlDbType .VarChar), new System.Data.SqlClient. SqlParameter ( "@S_PHONE" , System.Data. SqlDbType .Text)}); // // sqlSelectCommand1 // this .sqlSelectCommand1.CommandText = "SELECT S_ID, S_NAME, S_ADDRESS, S_PHONE\r\nFROM STUDENT" ; this .sqlSelectCommand1.Connection = this .sqlConnection1; // // sqlInsertCommand1 // this .sqlInsertCommand1.CommandText = "INSERT INTO [STUDENT] ([S_ID], [S_NAME], [S_ADDRESS], [S_PHONE]) VALUES (@S_ID, @" + "S_NAME, @S_ADDRESS, @S_PHONE)" ; this .sqlInsertCommand1.Connection = this .sqlConnection1; this .sqlInsertCommand1.Parameters.AddRange( new System.Data.SqlClient. SqlParameter [] { new System.Data.SqlClient. SqlParameter ( "@S_ID" , System.Data. SqlDbType .Int, 0, "S_ID" ), new System.Data.SqlClient. SqlParameter ( "@S_NAME" , System.Data. SqlDbType .VarChar, 0, "S_NAME" ), new System.Data.SqlClient. SqlParameter ( "@S_ADDRESS" , System.Data. SqlDbType .VarChar, 0, "S_ADDRESS" ), new System.Data.SqlClient. SqlParameter ( "@S_PHONE" , System.Data. SqlDbType .Text, 0, "S_PHONE" )}); // // sqlDataAdapter1 // this .sqlDataAdapter1.InsertCommand = this .sqlInsertCommand1; this .sqlDataAdapter1.SelectCommand = this .sqlSelectCommand1; this .sqlDataAdapter1.TableMappings.AddRange( new System.Data.Common. DataTableMapping [] { new System.Data.Common. DataTableMapping ( "Table" , "STUDENT" , new System.Data.Common. DataColumnMapping [] { new System.Data.Common. DataColumnMapping ( "S_ID" , "S_ID" ), new System.Data.Common. DataColumnMapping ( "S_NAME" , "S_NAME" ), new System.Data.Common. DataColumnMapping ( "S_ADDRESS" , "S_ADDRESS" ), new System.Data.Common. DataColumnMapping ( "S_PHONE" , "S_PHONE" )})}); // // Form1 // this .AutoScaleDimensions = new System.Drawing. SizeF (6F, 13F); this .AutoScaleMode = System.Windows.Forms. AutoScaleMode .Font; this .ClientSize = new System.Drawing. Size (463, 266); this .Controls.Add(s_PHONELabel); this .Controls.Add( this .s_PHONETextBox); this .Controls.Add(s_ADDRESSLabel); this .Controls.Add( this .s_ADDRESSTextBox); this .Controls.Add(s_NAMELabel); this .Controls.Add( this .s_NAMETextBox); this .Controls.Add(s_IDLabel); this .Controls.Add( this .s_IDTextBox); this .Controls.Add( this .sTUDENTBindingNavigator); this .Name = "Form1" ; this .Text = "Form1" ; this .Load += new System. EventHandler ( this .Form1_Load); ((System.ComponentModel. ISupportInitialize )( this .studentDataSet)).EndInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingSource)).EndInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingNavigator)).EndInit(); this .sTUDENTBindingNavigator.ResumeLayout( false ); this .sTUDENTBindingNavigator.PerformLayout(); this .ResumeLayout( false ); this .PerformLayout(); } #endregion private studentDataSet studentDataSet; private System.Windows.Forms. BindingSource sTUDENTBindingSource; private student.studentDataSetTableAdapters. STUDENTTableAdapter sTUDENTTableAdapter; private System.Windows.Forms. BindingNavigator sTUDENTBindingNavigator; private System.Windows.Forms. ToolStripButton bindingNavigatorAddNewItem; private System.Windows.Forms. ToolStripLabel bindingNavigatorCountItem; private System.Windows.Forms. ToolStripButton bindingNavigatorDeleteItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveFirstItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMovePreviousItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator; private System.Windows.Forms. ToolStripTextBox bindingNavigatorPositionItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator1; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveNextItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveLastItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator2; private System.Windows.Forms. ToolStripButton sTUDENTBindingNavigatorSaveItem; private System.Windows.Forms. TextBox s_IDTextBox; private System.Windows.Forms. TextBox s_NAMETextBox; private System.Windows.Forms. TextBox s_ADDRESSTextBox; private System.Windows.Forms. TextBox s_PHONETextBox; private System.Data.SqlClient. SqlConnection sqlConnection1; private System.Data.SqlClient. SqlCommand sqlCommand1; private System.Data.SqlClient. SqlCommand sqlSelectCommand1; private System.Data.SqlClient. SqlCommand sqlInsertCommand1; private System.Data.SqlClient. SqlDataAdapter sqlDataAdapter1; } } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// form1.cs using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Text; using System.Windows.Forms; namespace student { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void sTUDENTBindingNavigatorSaveItem_Click( object sender, EventArgs e) { sqlConnection1.Open(); sqlDataAdapter1.InsertCommand.CommandText= "INSERT INTO STUDENT (" + "S_ID, S_NAME, S_ADDRESS, S_PHONE" + ") VALUES ('" + s_IDTextBox.Text + "', '" + s_NAMETextBox.Text + "', '" + s_ADDRESSTextBox.Text + "', '" + s_PHONETextBox.Text + "')" ; sqlDataAdapter1.InsertCommand.ExecuteNonQuery(); sqlConnection1.Close(); this .Validate(); this .sTUDENTBindingSource.EndEdit(); this .sTUDENTTableAdapter.Update( this .studentDataSet.STUDENT); } private void Form1_Load( object sender, EventArgs e) { this .sTUDENTTableAdapter.Fill( this .studentDataSet.STUDENT); } } } Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 11
 - How to migrate from MySQL 4.1 to MS SQL Express 2005 I am trying to migrate from MySQL 4.1 to MS SQL Express 2005 1. do i need to create an empty db under Express 2. can this be done from within Express by pulling from MySQL into Express or do I need to work from command lines 3. what would be the cleanest way to approach this I have a MySQL dump and did look at the result from within Express, but it was not an import, I would like to find a way to import if possible that data. Table by table would be fine. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 12
 - Parent - Multiple Child Package Execution Could you use two Execute Package tasks, one configured for executing on the file system, the other for the database Then use precedence constraints to control which one executes. So you'd pass in two variables - one being the connection to the package, the other setting a variable that controls which package executes. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 13
 - msdb restore on new server One more thing. According to this (reference http://support.microsoft.com/kb/915845 ): ... -- Find the jobs to update. These jobs must match all of the input -- criteria, unless all of the inputs are null. In this case, -- examine all jobs. The jobs must also be jobs created locally, -- such as sysjobs.originating_server_id = 0 . These jobs should not be a job that we run -- because another server told us to. Furthermore, if the job -- is local but it is meant to be run on a target server, we send an -- update for the job. declare @jobsToUpdate TABLE (job_id uniqueidentifier not null) insert into @jobsToUpdate select job_id from sysjobs where originating_server_id = 0 -- local jobs and ((COALESCE(@job_name, sysjobs.name) = sysjobs.name) and (COALESCE(@job_id, sysjobs.job_id) = sysjobs.job_id) and (COALESCE(@owner_name, suser_sname(sysjobs.owner_sid)) = suser_sname(sysjobs.owner_sid))) ... The originating_server_id's in sysjobs on SQL_TEST is already 0 (local jobs). If anyone has any details on how to script the Maintenance Plans then please let me know. Thanks, Mark Tabash Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 14
 - Some things about SMO Hello, Which version of SQL Server are you using ( no Job Agent with SQL Server Express ) Have a nice day Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 15
 - Add hidden field to report I was able to resolve this by using the rowcount function, and just specifying the previous list as the scope to count. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 16
 - Making Reports Customizeable for Users on a .NET site We are doing the same thing, using IFrames with the report displayed in the IFrame. We did some custom code to facilitate the moving around of the frames within a page. This really would not be 1 report, but a web page with multiple reports being displayed in multiple IFrames. HtH BobP Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
- Next
 - 1
 - How to deliver a report dynamically based on the dataset with standard edition? I don't see a reason why this shouldn't work. You can write a script task to call down to the SSRS web service and request the report by invoking the Render method . Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 2
 - Design table need help Isn't this a self-referential ParentID relationship You can do it all in one table (I think): tbProject ProjectID int IDENTITY (1,1) (PK) ProjectName nvarchar(255) ParentProjectID int NOT NULL (FK --> projectID) TopLevelProjectID int NOT NULL (FK --> ProjectID) Requirement nvarchar(255) Create a project, it gets ProjectID = 1, and since it has no Parent, it's ParentID = 1 that means that it's a Top-Level project, so it's TopLevelProjectID = 1. A sub project would have ProjectID = 2 (or whatever the next avilable ID is), a ParentProjectID = 1, and a TopLevelProjectID = 1. And, if this sub had a sub, then: ProjectID = 3 (or next available ID) ParentID = 2 ('cause that's one level UP from this project) TopLevelProjectID = 1 ('cuase that the top of the tree from this project) With this, you can use something like: Update Set REquirment = Requirment + " SOME NEW STRING " where TopLevelProject = 1 Code Block create table #Projects ( ProjectID int identity ( 1 , 1 ) , ParentID int , TopLevelID int , ProjectName varchar ( 255 ) , ProjectRequirement varchar ( 255 ) ) insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1' , 1 , 1 , 'some thing or other' insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 2' , 2 , 2 , 'do this now' insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 3' , 3 , 3 , ' FOOBAR the 3rd' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A' , 1 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 2: Sub A' , 2 , 2 insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1: Sub B' , 1 , 1 , 'Hey, here''s another one!!' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A: Sub i' , 4 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A: Sub ii' , 4 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1: Sub A: Sub ii: Sub a:' , 8 , 1 , 'Do it. Do it now!' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 3: Sub A' , 3 , 3 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 3: Sub A: Sub i' , 10 , 3 ; with CTE as ( select ProjectName as [ProjectName] , ProjectName as [ParentProject] , ProjectName as [TopLevelProject] , convert ( varchar ( 4000 ), IsnUll ( ProjectRequirement , '' )) as [REQ] , ProjectID from #Projects where TopLevelID = ProjectID union all select P . ProjectName , cte . [ProjectName] , cte . [TopLevelProject] , convert ( varchar ( 4000 ), CTE . REQ + ': ' + isnull ( ProjectRequirement , '' )), p . ProjectID from CTE inner join #Projects P on P . ParentID = cte . ProjectID where P . ProjectID <> p . ParentID and p . ProjectID <> p . TopLevelID ) select * from CTE order by TopLevelProject , ParentProject drop table #Projects Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 3
 - Estimating hardware requirements for a SQL Server 2005 installation Is there any good online documentation describing rules of thumb for estimating and planning a SQL Server 2005 deployment in support of a Windows rich client/WCF services architecture TIA, Ian Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 4
 - Online/Offline Application that must synchronize with SQL 2005 Hi ! I must developp a WPF Application with online and offline capabilities! First I think to use XML file on the local application and transfer these XML files to a webservice that will synchronize them with the SQL 2005 Server BUT I read about "Replication"... and I think it will be much simpler to implement!!! Do you think it is a good idea to have a "local" SQL Express database and replicate it (when connection available is) with the principal database that will run a standard SQL 2005 version! Do you have another suggestion to make such an application Thanks for help!!! PlaTyPuS PS: when the sql express solution a good idea is, does it give a simple solution to programm an automatic synchronization every hour Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 5
 - SSAS - Custom Rollup in Snapshot Cube - SQL 2000 vs SQL 2005 Hi Linda, A couple of clarifications: Linda Cornerstone wrote: I tried 'Average of Children' and it does give the correct results Did you mean to say that it didn't give you the correct results (for example, this could happen if there are multiple date dimensions; or if [Snapshot Date] is not identified as a date dimension) Linda Cornerstone wrote: In the Shaphot Date dimension properties for Week, Month, Quarter and Year for CustomRollupColumn I am using dimDate.Custom Rollup There are 2 issues with this that I can see: If the Shaphot Date dimension is regular (not parent-child), the article suggests incorporating expressions in the cube MDX script at the different levels, rather than custom rollups - these would probably perform better. However, if you want to make the Custom Rollup work, the issue may be that CustomRollupColumn is an attribute rather than a dimension property . So, assuming that you've set this property separately for each of the Week, Month, Quarter and Year attributes, it's safer to explicitly specify a hierarchy in the expression, like: 'Avg([Snapshot Date].[Year-Quarter-Month-Week].CurrentMember.Children)' . But this may only work (assuming that there is a [Year-Quarter-Month-Week] hierarchy ) if it is a natural hierachy . SQL Server 2005 Books Online Attribute Relationships ... Natural Hierarchy Relationships A hierarchy is a natural hierarchy when each attribute included in the user-defined hierarchy has a one to many relationship with the attribute immediately below it. ... Relationships representing natural hierarchies are enforced by creating an attribute relationship between the attribute for a level and the attribute for the level below it. ... Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 6
 - Problem returning SQL data I'm having trouble with the display of data when I test my asp page. I basically retrieves or pulls data from different tables in a database. Based on an ID number (which I can change manually by typing in a value and appending it to the URL), it shows GuestName, GuestDescription and URL as text link. I can get it to do that much. But for some reason it's not showing the URL associated with the Guest Name. I dont think it's the display section of my code. I think it's the Select statement. Here is what the output looks like in my Firefox and IE browsers when I test. Some data has been changed to protect it's integrity: (Name in bold) Mark Crisp's author of The Bush Lexicon. His new book... Related Links: John Doe interviewed by Susan Smith, 123 News What it should say in the link is this: Mark Crisp's blog (as text link) When I test for different data I just change the end of the URL like this: defaultprogram4.asp ID=1234 (this number represents an ID column in a table) Code Snippet <% set con = Server.CreateObject("ADODB.Connection") con.Open "File Name=E:\webservice\Company\Company.UDL" set rs = Server.CreateObject("ADODB.Recordset") id=request.querystring("id") 'If this line is commented out the page will be blank. 'However you can still append a record number to the end of the URL and display that one. IF id <> "" then id=id else id="1234" end if 'This line shows the default record of 1234. If this line is commented out the page will ONLY show the default record but will NOT allow you 'to append a different number strSQL = "SELECT *, T_Programs.ID AS Expr1, T_ProgramGuests.ProgramID AS Expr2, T_ProgramGuests.GuestName AS Expr3, T_ProgramGuests.GuestDescription AS Expr4, T_ProgramLinks.URL AS Expr5, T_ProgramLinks.Description AS Expr6 FROM T_ProgramGuests CROSS JOIN T_Programs CROSS JOIN T_ProgramLinks WHERE (T_ProgramGuests.ProgramID = '" & id & "')" rs.Open strSQL,con 'open a connection to the database %> <% Response.Write RS ("GuestName") %> <% Response.Write RS("GuestDescription") %> Related Links: <li class='basic'><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></li>  <% recProgram.Close con.Close set recProgram = nothing set con = nothing %> Bottom line here is this: Why would I be seeing one name but a link not associated with that name It's as though it's reading a name from the ProgramGuests table and a URL from the ProgramLinks table (Except that: it shows a completely different unrelated URL to that name). What am I missing Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 7
 - Jump to report Navigation Can I have a report that is nothing more than a parameter and when the user selects from the list it will jump to another report based on which parameter was selected I can create a report with a text box that I can click to jump. I'd like to be able to eliminate the click on text box if possible and jump directly from parameter select pull down box. Thanks. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 8
 - Error using /SET I have a data importing .dtsx file that I would like to point towards another server on occasion. I tried: DTEXEC /FILE "fubar.dtsx" /SET "\Package.Connections[ConnectionManagerName].Properties[ConnectionString];Data Source=NEWSVR;Initial Catalog=Fubar;Provider=SQLNCLI;Integrated Security=SSPI;Auto Translate=False;" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI but I keep getting the error: Argument ""\Package.Connections[ConnectionManagerName].Properties[ConnectionString];Data Source=NEWSVR;Initial Catalog=Fubar;Provider=SQLNCLI;Integrated Security=SSPI;Auto Translate=False;"" for option "set" is not valid. Staring at the XML within the .dtsx file gave me no insight other than I suspect the "ConnectionManagerName" is the problem. How do I figure out the magic incantation It's definitely not as trivial as using '-S NEWSVR' on SQLCMD! Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 9
 - How to remove Reporting Server Sp2 Hi Tomas, Assuming you want to move forward to a newer SP or QFE in the future, you'll want to get the root problem resolved. There may be a workaround that doesn't require rolling back to RTM/SP1, for instance. If you're comfortable sharing your report definition here and a description of the problem with the report after upgrade, please do so. Another option is to use Connect to log the problem as a product bug: http://connect.microsoft.com/SQLServer/Feedback Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 10
 - Problems with ProcessAdd and secondary DataSource We have a SSAS 2005 cube in place and have been using ProcessAdd XMLA for some time with success. The current environment has a single datasource called 'Sales' and a single DSV called 'Sales'. The sales datasource is a DB2 database. Everything works great. In preperation for adding some new data sources, we have built a version in our test environment that is configured with two data sources and a single DSV. 'Master' is the primary DS and it points to an empty DB on SQL Server. 'Sales' is a secondary DS and it points to the original DB2 database. There is a single DSV that is called 'Master'. Everything works well through SSMS, but I can't seem to build the correct XMLA to get ProcessAdd working again. If I build it with the 'Master' datasource and DSV it gives me a bunch of errors that arent specific enough for me to take action. Things like Error ErrorCode = " 3240034316 " Description = " Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DIM IBU HIER VER', Name of 'IBU' was being processed. " Source = " Microsoft SQL Server 2005 Analysis Services " HelpFile = "" If I build the xmla for ProcessAdd with the 'Sales' datasource and 'Master' DSV and then rename 'Master' to 'Sales' it appears to work and executes successfuly.. However, when you watch the activity on the profiler, it is not using the query from the out-of-line DSV query but instead it goes back to SSAS DB and uses the query stored there. All of the ProcessAdd examples I have seen seem to deal with a single DSV and DS. Can there be multiple datasources in the ProcessAdd xmla Is it possible to make this scenario work Thanks, Marty Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 11
 - Relative date ---'Rolling 3 months' --help please Please use the expression provided above. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 12
 - Rename SQL Bit in Reporting services Hello, What is the best way to rename a bit "True/False" to "Open/Closed" or "yes/no" in the expression editior. Thanks B Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 13
 - Writeback with ProClarity Hi there, I need to writeback to my cube. I've set it all up on the cube, and I can go into SSMS, execute this command: update cube [NHCFE DW] set ([DIM TIME].[Financial].[Fin Year Name].&[2006], [DIM GL Transactions].[Codes Hierarchy].[GL Account].&[106], [Measures].[Forecast Value])=100 And it works just fine. Now all I need is a client tool to enable users to write back. Imagine my disappointment when I saw that Excel 2007 just refuses to play. Not only that, but you can't work around with the Add-In that used to allow Excel 2003 to do writeback. A bit embarrassing, especially as I'd insisted on Excel 2007 being rolled out, because it 'works really, really well with cubes.' OK, I know a little bit of ProClarity, so I reached for that. Sure enough, there is writeback built in there. However, It's working in such a weird way that I'm not sure whether it's going to be useable or not. Could I ask you lot to sense check what's happening here, because I may be missing something obvious. I assumed that ProClarity would just issue the mdx pretty much as I'd written above. When I trapped it with Profiler, I saw that It was explicitly sending an [All] for every attribute in the cube. OK, verbose, but no big problem. It was explicitly sending the default member on the time dimension. This IS a big problem. I have a default member set up in the cube calcualtions - this sort of thing: CALCULATE; ALTER CUBE CURRENTCUBE UPDATE DIMENSION [DIM Time], DEFAULT_MEMBER = StrToMember("[DIM Time].[Calendar].[Time Key].&[" + format(DateAdd("d",-1,now()),"yyyyMMdd") +"]"); So, the default member on the time dimension is alwys yesterday. Up to now, this has been a great help to users. Now however, when ProClarity sends the update command to the Cube, it starts like this: (red represents default member) UPDATE CUBE [NHCFE DW] SET ( [Measures].[Forecast Value], [DIM TIME].[Calendar].[Time Key].&[20070813], [DIM TIME].[Hierarchy].[Fin Period Key].&[200612], [DIM TIME].[Year].&[2007], [DIM TIME].[Month Key].&[200708], [DIM TIME].[Time Key].&[20070813], [DIM TIME].[Ac Year Name].&[06/07], [DIM TIME].[Fin Period Key].&[200612], [DIM TIME].[Financial DIM TIME Calculations].&[Current DIM TIME], [DIM TIME].[Fin Year Name].&[2006], [DIM STAFF].[STAFF ID].[All], [DIM STAFF].[NAME].[All], [DIM ROOM].[Site-Room].[All], etc etc etc etc So, I can only update the Financial Period that contains the default member.i,e the current one. Anything else, and the co-ordinate doesn't exist. I don't even want the default member to be getting involved here, I just want to specify the Financial Periods that I want to update. What's going on here What am I doing wrong Any help gratefully received... edit >here's the error Profiles throws:"Errors in cell writeback: Unable to write back to a cell because the specified cell does not exist in the cube space. <edit Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 14
 - How to selectively apply a filter Note quite sure I got what you were saying. But did you try use multi-valued parameter instead Once you have SP2 installed, you should have the Select All checkbox available by default. Then in your stored procedure, you will need to parse the input parameter value since it can have multiple selections. Using split on "," should do it. If you need to stay with the hard coded All instead, I usually set the value for All to NULL. Then you should be able to handle the NULL value in your stored procedure. HTH. Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 15
 - datetime format setting --> mm-dd-yyyy instead of dd-MM-yyyy in SQL Server 2005 / expre(is it with sql server login language You don't understand you need to change to language neutral format and you need to use overloads of the DateTime.ToString and other formatting for .NET DateTime in the application. I have covered that in the thread below. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1837895&SiteID=1 Tag: Connections through a server alias, IP address, or any other alternate name are not supported.
 - 16
 - What types of permissions are required for the anonymous account to access local cubes? I created a local cube from an AS 2005 cube and when I try to connect to it using a web application the following exception is returned: Exception: A connection cannot be made. Ensure that the server is running. And the connection string that I am using is: " Provider=MSOLAP;Data Source=MyPath\LocalcubeName.cub;Catalog=Local cube 1;MDX Compatibility=2; " Everything works properly in the following cases: 1. If I am debugging. 2. And also outside of debugging if I change the anonymous user to my network account and change web.config to use impersonation. What types of permissions are required for the anonymous account to access the local cube Thanks, Abdel Tag: Connections through a server alias, IP address, or any other alternate name are not supported.

Ziad Adada

I am trying to connect to another sql server in my company using the IP address for exmp. : 111.111.1.1\SQL2005 but it show this message:

Connections through a server alias, IP address, or any other alternate name are not supported. it was working well on SQL2000

Please help

Top

Re: Connections through a server alias, IP address, or any other alternate name are not supported.

Gary Chen

Have you tried to create an alias in SQL server configuration manager

Gary

Top

Re: Connections through a server alias, IP address, or any other alternate name are not supported.

Ziad Adada

Yes I did and is still not accepting

Top

Re: Connections through a server alias, IP address, or any other alternate name are not supported.

Tarek Ghazali

Hi Ziad,

Can you explain what you did exactly did you create the following:

1-create alisan name : mysecondserver

2-port: by default empty , you need to specify the port in case you have firewall issue.

3-protocol: TCP/IP or other..

4-server: IP\instance_name

NB: to be sure about server name on the second server select @@servername in query window on the second server.

If you still cannot connect , please send me a direct email, you can find it on my site and i will try to discuss it with you.

Tarek Ghazali

SQL Server MVP

http://www.sqlmvp.com

Top