score:1
Could be a lot of things, since you didn't specify what error you got, but as a general reference this site: http://www.connectionstrings.com/sql-server/ gives you lots of things to try.
Other things to confirm: is the firewall allowing traffic thru? Is the port set to something other than the default of 1433; did you configure the server to allow remote connections? Is tcp/ip enabled?...etc.
score:3
No ports where declared in the IP eg .192.168.0.1:1033 , And instead of Database use Initial Catalog=datos
On the server you would have to set in sql server management the option of allowing remote connections to true, then in windows firewall activate the port used to connect to the sql server.
Full idea with the connection string...
"Server=192.168.0.1:1033\SQLEXPRESS;Initial Catalog=datos;uid=userid;pwd=password"
More questions
- Connecting to Oracle Database using Sql Server Integration Services
- Connecting to local SQL Server database using C#
- Connecting to a SQL Server database using VB.NET
- Issue connecting to my sql database using a REST api server with Node.js
- node.js is not connecting to SQL Server database using SQL Server authentication
- Connecting to SQL Server Database using a Hosted Web Application
- Connecting to a remote web server and SQL database using Visual Studio
- difficulty connecting to SQL Server database inside a docker container using Sequelize
- ASP.NET Core MVC: connecting to existing database using SQL Server authentication
- Connecting to SQL Server 2008 database using asp
- How can I change my default database in SQL Server without using MS SQL Server Management Studio?
- How do you check what version of SQL Server for a database using TSQL?
- How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?
- Connecting to SQL Server using windows authentication
- Connecting to MS SQL Server with Windows Authentication using Python?
- Drop primary key using script in SQL Server database
- How do I connect to a SQL Server 2008 database using JDBC?
- Connecting to SQL Server 2012 using sqlalchemy and pyodbc
- How to insert a blob into a database using sql server management studio
- How to restore database using sqb files in SQL SERVER
- Connecting to SQL Server LocalDB using JDBC
- Writing a csv file into SQL Server database using python
- Connecting to sql server database mdf file without installing sql server on client machine?
- Inserting values into a SQL Server database using ado.net via C#
- How to delete leading empty space in a SQL Database Table using MS SQL Server Management Studio
- Error connecting to a remote SQL server database Visual Studio 2017
- Connecting to Microsoft SQL Server using Clojure
- How to tell using T-SQL whether a SQL server database has the TRUSTWORTHY property set to on or off
- Best way to access a SQL Server database using C# .Net
- Cannot connect to SQL Server database using pymssql but can connect using underlying freetds tsql
More questions with similar tag
- How to skip values that have NULL values in a TSQL query?
- SQL select based on non-null values in another table
- No foreign key restraints on a temporary table? SQL Server 2008
- Find a string based on input Characters in sql
- How can I visualize the value of nvarchar(max), with max>65535, from SQL Server database?
- SQL Return last record where column value changed and amount of change
- Different models taking data from different tables from the same database ASP.NET MVC 4
- sql replace all characters between two strings
- sp_executesql runs in milliseconds in SSMS but takes 3 seconds from ado.net
- Group by According to three tables
- Permissions required for the DATA folder
- How exactly can i troubleshoot MEMORY_ALLOCATION_EXT waits?
- New Row into SQL Server with Data Set [asp.net, c#]
- How to SUM the values in a column in SQL
- Entity Framework and Different Environments (Dev/Production)
- Get values from SQL table along with column name as list in Python
- SQL trouble! IF/CASE help required
- any practices ,samples for ERD?
- Stored proc to copy relational data (SQL Server 2000)
- SQL Server inserting huge number of rows to a table with default values and identity column in it
- Trigger to not delete Data from a table
- How to return records between a Start Date and End Date
- Create failed for Job 'SSIS Package Exec'
- Error with creating sql data name
- Creating View from Related Child Tables
- insert unique values only
- Configure ADP application to use a different database...?
- How to simplify this replace query?
- SQL Server inserts and select taking long time
- What's the best way to get intersected data from one table?